如何快速修改文件重命名命名
In Excel, you can give a name to a range of cells, then use that name in a formula, or to create a drop down list in a cell. Later, if you decide that the range should be bigger or smaller, you can change address of Excel named range.
在Excel中，可以给一系列单元格命名，然后在公式中使用该名称，或在单元格中创建下拉列表。 以后，如果您确定范围应该更大或更小，则可以更改名为range的Excel地址。
In the screen shot below, the list of names is a named range – EmpList. Select that name in the Name Box, and Excel selects the range on the worksheet.
在下面的屏幕快照中，名称列表是一个命名范围– EmpList。 在名称框中选择该名称，然后Excel在工作表上选择范围。
In this video you can see the steps for setting up a simple range, and then using that name in your workbook.
在此视频中，您可以看到设置简单范围的步骤，然后在工作簿中使用该名称。
(Changing a Name’s Range)
After you create a name, you might need to change the range of cells that it refers to.
创建名称后，可能需要更改其引用的单元格范围。
Maybe you’ve added a row or two, or you’d like to include another column. Someone asked how to do that, in the comments on that YouTube video.
也许您添加了一两行，或者您想添加另一列。 有人在该YouTube视频的评论中问如何做到这一点。
- "How can you get rid of the name you gave to the cells? I have 2 cells selected and named, when I add a third cell and select all three cells, it doesn't allow me to rename it."
In the screen shot below, a new name has been added to the end of the list, and it doesn’t show up in the drop down, which is based on the EmpList range. As the commenter noted, you can’t just select a new range of cells on the worksheet, and give them an existing name.
在下面的屏幕快照中，新名称已添加到列表的末尾，并且没有出现在基于EmpList范围的下拉列表中。 正如评论者所指出的，您不能只是在工作表上选择一个新的单元格范围，并为其指定一个现有名称。
(Option 1: Dynamic Ranges)
If the range will change frequently, it’s better to set up a dynamic range, which will adjust automatically. You can create an Excel Table to do this in Excel 2007 or later.
如果范围会经常变化，则最好设置一个动态范围 ，它会自动调整。 您可以创建一个Excel表以在Excel 2007或更高版本中执行此操作。
In Excel 2003, select a cell in the list, and press Ctrl + L, to create a List. A named range based on a List will automatically include new items.
在Excel 2003中，在列表中选择一个单元格，然后按Ctrl + L来创建一个列表。 基于列表的命名范围将自动包括新项目。
For earlier versions, where Lists and Tables are not available, you can use an INDEX for dynamic range or OFFSET formula.
对于早期版本(其中列表和表格不可用)，可以将INDEX用于动态范围或OFFSET公式 。
(Option 2: Redefine the Named Range)
For a static range, that rarely changes, you can follow these steps to change the range address:
对于很少更改的静态范围，可以按照以下步骤更改范围地址：
- On the Ribbon, click the Formulas tab
- Click Name Manager
- In the list, click on the name that you want to change
- In the Refers To box, correct the range reference, or drag on the worksheet, to select the new range.
- Click the check mark, to save the change
- Click Close, to close the Name Manager
(Video: Change a Named Range)
To see the steps, please watch this short video. It shows you how to set up the name, create a drop down list, and then change the name's range of cells.
要查看步骤，请观看此简短视频。 它显示了如何设置名称，创建下拉列表以及如何更改名称的单元格范围。
演示地址
(More Information on Names)
There’s a page on my Contextures site with more information on named ranges, including the rules for range names.
我的Contextures网站上有一个页面，其中包含有关命名范围的更多信息 ，包括范围名称的规则。
You can also see how Roger Govier uses dynamic names based on tables, to create dependent drop down lists on the worksheet.
您还可以看到Roger Govier如何使用基于表的动态名称在工作表上创建相关的下拉列表。
翻译自: https://contexturesblog.com/archives/2014/03/18/change-address-of-excel-named-range/
如何快速修改文件重命名命名
