Well, I finally finished creating all the names in my client's Excel workbook, and sent the file back to them.
好了,我终于完成了在客户的Excel工作簿中创建所有名称的操作,并将文件发送回了它们。
To help my client see what I'd done, I created a list of the names in the workbook, and sent it along with the main file. It was also a quick way for me to double-check the names and their formulas.
为了帮助客户了解自己的工作,我在工作簿中创建了一个名称列表,并将其与主文件一起发送。 对我来说,这也是一种快速检查名称及其公式的快速方法。
创建名称列表 (Create the List of Names)
Here are the steps to create a list of names:
以下是创建名称列表的步骤:
- Insert a new worksheet, or select a cell in a blank area of an existing worksheet. On the Ribbon, click the Formulas tab. 插入一个新的工作表,或在现有工作表的空白区域中选择一个单元格。 在功能区上,单击“公式”选项卡。
- In the Defined Names group, click Use in Formula 在“定义的名称”组中,单击“在公式中使用”
![Excel Name Use in Formula Excel Name Use in Formula](https://i-blog.csdnimg.cn/blog_migrate/2cea99c2269ed7f907aa12d2e961ac80.gif)
- At the bottom of the list of names, click Paste Names (In Excel 2003, click Insert | Name | Paste) 在名称列表的底部,单击“粘贴名称”(在Excel 2003中,单击“插入” |“名称” |“粘贴”)
![Excel Name Paste Names Excel Name Paste Names](https://i-blog.csdnimg.cn/blog_migrate/f56389acabdf3ff631bfa44977247cb4.gif)
- In the Paste Name dialog box, click Paste List. 在“粘贴名称”对话框中,单击“粘贴列表”。
![Excel Name Paste Name Excel Name Paste Name](https://i-blog.csdnimg.cn/blog_migrate/f302d621a663fe70db311470c428f10a.gif)
A 2-column list of names will be inserted, starting in the selected cell, so make sure you have room for your list.
从所选单元格开始,将插入两列名称列表,因此请确保您有足够的空间容纳列表。
![Excel Name List Excel Name List](https://i-blog.csdnimg.cn/blog_migrate/41246ca09bd9a38d3474a958982ed49d.gif)
清单中有什么? (What's in the List?)
The list of names will contain all the workbook level names, unless there's a duplicate sheet level name on the sheet where the name list is pasted. In that case, the sheet level name appears in the list, instead of the workbook level name.
名称列表将包含所有工作簿级别的名称,除非粘贴名称列表的工作表上存在重复的工作表级别名称。 在这种情况下,工作表级别名称将显示在列表中,而不是工作簿级别的名称。
名称管理器加载项 (Name Manager Add-In)
I've mentioned Jan Karel Pieterse's Name Manager before, as one of my favourite Excel add-ins. If you're working with names, in any version of Excel, you should download and install it. It's free, easy to install, and simple, but powerful, to use.
我之前提到过Jan Karel Pieterse的名称管理器,这是我最喜欢的Excel加载项之一 。 如果要使用名称,则在任何版本的Excel中,都应下载并安装它。 它是免费的,易于安装的,并且操作简单但功能强大。
You can download Name Manager for Excel 2007 or earlier versions. ______________
翻译自: https://contexturesblog.com/archives/2009/09/25/create-list-of-names-in-a-workbook/