Defined names are a very useful tool for authoring formulas. Defined names allow users to name cell ranges, formulas, and values and refer to those names in their formulas. Used in formulas, defined names make formulas easier to read and more robust. Additionally, when writing formulas, names are less likely to get mis-typed than cell references, and they are easier to remember than cell references (“Tax_Rate” as opposed to “G36”). In this article, I would like to discuss some of the work we’ve done to defined names in Excel 12 – specifically, how we have added new management and creation UI, and how we have added comments to names.
在公式书写时,名称是一个很实用的工具。用户可将单元格引用、公式和常量定义成名称,并在创建公式时引用它们。应用名称可使公式变得比较容易理解和维护。此外,相对引用单元格区域而言,在写公式的时候使用名称比较不会出错,而且方便记忆(例如,用“Tax_Rate(税率)” 而不用“G36”)。本文讨论名称的改进——重点介绍新增的创建和管理名称的界面以及如何给名称添加注释。
The new Manage Names Dialog
新的名称管理对话框
Probably the most common piece of feedback we receive about defined names is that the user interface we provide to manage names is inadequate. When we visit customers on site, we often see workbooks with dozens or hundreds and even thousands of defined names, which makes tasks like deleting multiple names, renaming names, and finding broken ones challenging. Enter the new Manage Names dialog, which is designed specifically for viewing and managing the defined names in a workbook.
最常见的关于名称的抱怨可能是名称管理界面的缺陷带来的。我们拜访客户时,常会见到客户的工作簿的名称达到成百上千之多。在执行删除名称(多个),重命名和查找错误结果值名称等任务时,这会带来许多麻烦。新的名称管理对话框,正是专门设计用来查看和管理工作簿中的名称的。
The entry point to the Manage Names dialog is in the centre of the new Formulas tab. Here is a shot of the Formulas tab in current builds – you can see a big button titled “Name Manager”.
名称管理对话框功能的按钮设在新的格式菜单中。目前版本中,只要点击“格式”标签,就可以看到一个叫“Name Manager (名称管理)”的大按钮。
When you click on the Name Manager button, you will see the Manage Names dialog.
再点击该按钮,你会看到一个名称管理对话框。
Using this dialog, you can:
这个对话框用来:
View existing Defined Names
查看已有的名称
• See the name’s reference (“Refers to” control), the name’s scope (“Scope” Column), and the name’s value (“Value” Column – note, this displays error values as well)
• 查看名称的引用范围(“Refers to” 控件)、适用范围(“Scope” 栏)和结果值(“Value” 栏——注:错误结果值也会显示出来)
• Confirm whether it is referenced in the grid or not (the “In Use” column)
• 确认该名称是否已在表格中使用(“In Use”栏)
Create New Names
创建名称
• Easily define the scope of a name in the New Name dialog (dialog discussed below)
• 在新的名称框对话框中,可以很容易地指定名称的适用范围(在之后的对话框的讨论中)
• Easily set the name reference
• 方便地设置名称引用范围
Edit existing names
编辑已有的名称
• You can now rename a name without having to redefine it from scratch
• 名称可以重命名,不必再为了改名字而重新去定义一个名称。
• You can quickly modify scope from the Edit Name dialog (dialog discussed below)
• 可以很快地在编辑名称对话框中修改名称的适用范围(在之后的对话框的讨论中)
Delete Names quickly
快速删除名称
• Select and delete multiple names at once
• 一次性选择和删除多个名称
Sort the Name list
名称排序
• You can sort the name list by clicking on the column headers
• 单击栏标题可以对名称进行排序
Resize the Manage Names dialog
• 调整名称对话框的大小
上一篇:excel入门教程:XII 筛选OLAP数据,以及一些“持续”改进(一) 下一篇:表格制作快速入门:快速比较不同Excel区域的数值(一)
郑重声明:本文版权归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。