表达式。CreateNames(顶部、左侧、底部、右侧) expression一个表示Range对象的变量。 参数 名称必需/可选数据类型说明 Top可选Variant如果该值为True,则使用顶部行中的标签创建名称。 默认值为False。 Left可选Variant如果该值为True,则使用左侧列中的标签创建名称。 默认值为False。
Click OK to add the name and close the dialog box.Note: A faster way to create a name is to use the Name box (to the left of the formula bar):Select the cell or range to name and then click the Name box and type the name. Press Enter to create the name.Press...
Here's how you can create a named range in your spreadsheet: On theFormulastab, in theDefined Namesgroup, clickDefine Name. In theNew Namedialog box, in theNamebox, type the name you want to use for your reference. Note:Names can be up to 255 characters in length. To specify the sc...
lTo create a named range 1.Navigate to theFormulastab and click onName Manager, whose shortcut key isCtrl+F3. In the pop-up box, clickNewto define a new named range. Then you can enter name for the range, set the scope (Workbook or Sheet), add comments and set the applied range ...
定义名称是Range对象下面的一个方法。表达式：Range.CreateNames(Top,Left,Bottom,Right)创建名称后可以在名称管理器当中查找和修改。其参数说明请看下图，不具体赘述了。CreateNames参数 NO.3 定义名称实际上是将一些重复使用的公式、常量作为一个模板进行引用。如有些数据是动态的，随着改变名称内容相应的引用了的单元...
3. Click on "Name Manager": In the "Defined Names" group, click on "Name Manager." This will open the Name Manager dialog box. 4. Click "New": In the Name Manager dialog box, click the "New" button to create a new named range. ...
Namespace: Microsoft.Office.Interop.Excel Assembly: Microsoft.Office.Interop.Excel.dll Creates names in the specified range, based on text labels in the sheet. C# 複製 public object CreateNames (object Top, object Left, object Bottom, object Right); Parameters Top Object Optional Object. ...
usingSpire.Xls;usingSpire.Xls.Core;namespaceCreateNamedRange_XLS{classProgram{staticvoidMain(string[]args){//创建Workbook实例Workbookworkbook=newWorkbook();//加载Excel文件workbook.LoadFromFile("test.xlsx");//获取第1张工作表Worksheetsheet=workbook.Worksheets[0];//定义第一个全局命名区域INamedRangeNamed...
usingSpire.Xls;usingSpire.Xls.Core;namespaceCreateNamedRange_XLS{classProgram {staticvoidMain(string[] args) {//创建Workbook实例Workbook workbook =newWorkbook();//加载Excel文件workbook.LoadFromFile("test.xlsx");//获取第1张工作表Worksheet sheet = workbook.Worksheets[0];//定义第一个全局命名区域INam...
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam! Related Links Using Names in Formulas Named Excel Tables Excel Names Macros Create Dynamic Ranges With a Macro Last updated:June 10, 2024 12:23 PM...