對編輯公式功能的改進Part 4_名稱

對編輯公式功能的改進Part 4_名稱

譯者：apolloh? 來源：http://blogs.msdn.com/excel 發表于：2006年7月7日

polFormula building improvements Part 4: Defined Names 對編輯公式功能的改進 Part 4：名稱

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. 最常見的關于名稱的抱怨可能是名稱管理界面的缺陷帶來的。我們拜訪客戶時，常會見到客戶的工作簿的名稱達到成百上千之多。在執行刪除名稱（多個），重命名和查找錯誤結果值名稱等任務時，這會帶來許多麻煩。新的名稱管理對話框，正是專門設計用來查看和管理工作簿中的名稱的。

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 ? 調整名稱對話框的大小

? Make the refers-to box as wide as you need, so the number of names you can see is limited only by your monitor size ? 根據需要調整refers-to box（引用范圍文本框）的寬度。這樣，名稱的可見程度僅僅取決于桌面窗口的大小

Filter the Name List 名稱篩選

One thing we would be interested in hearing is whether hidden names should be surfaced in this dialog.? The current design allows users to show hidden names using a control on the filter drop-down, but they are not displayed by default.? Our reasoning for this is that customers tell us hidden names cause many problems for users and generate helpdesk issues. At the same time, some solution providers use them as variables with the knowledge that you can’t see them in the UI.? Our current design would allow savvy users to find the hidden names without writing code.? Note, there is a workaround for solution developers, which is to use very hidden names which can be created by using the hidden namespace in XLM (i.e. SET.NAME) 我們假想有用戶需要將隱藏的名稱也顯示在對話框中。目前設計允許通過選擇過濾器上的選項來顯示隱藏名稱，默認設置為不顯示。之所以這么做，是因為用戶反映隱藏名稱會導致許多問題，并希望得到幫助。同時，一些方案提供商使用隱藏名稱作為變量，但它們在用戶界面看不到。目前的設計允許高級用戶不用寫代碼就能查到隱藏名稱。注：對方案開發者來說，有個變通的辦法——可利用XLM中的隱藏namespace達到真正隱藏名稱的目的。（例如，SET.NAME）

The New Name/Edit Name Dialog 新的名稱創建/編輯對話框

While we were improving name management, we set another goal to simplify the experience of creating a name. To do this, we created a dialog that surfaces the UI needed to define a new name or edit an existing name (the title of the dialog changes between New Name and Edit Name depending on the context of how it was launched).為此， Of note is the Scope drop down which allows the user to easily set the scope of their name to a specific sheet or the entire workbook (no more secret knock needed). 對于名稱管理的改進方面，我們還設定了另一個目標——簡化創建名稱的過程。我們新增了一個對話框作為用戶定義和編輯名稱的界面。（對話框的標題會隨著新增或是編輯功能的選擇而相應地發生變化）值得一提的是，可以通過適用范圍（Scope）的下拉列表選擇一個特定的工作表或整個工作簿，來設置名稱的適用范圍。

For mouse users, we’ve made it easier to get to the new name UI by adding a right-click menu option that will launch the dialog with the selected range in its refers-to box. 鼠標用戶可以方便地選擇一個范圍后，通過右鍵快捷菜單打開創建名稱對話框，refers-to box（引用范圍文本框）會自動帶入這個引用范圍。

Other entry points exist on the Ribbon and Manage names dialog. Excel 12 的新工具欄（Ribbon）和名稱管理對話框中，也有打開新建/編輯名稱對話框的地方。

Name Comments Finally, I’d like to talk about an enhancement to the Defined Name object itself – we have added a name comment property. The comment property allows the user to document what a name refers to, what it should and should not be used for, etc. This field can be edited from both the UI (New/edit name dialogs) and the OM and is surfaced as the name’s tooltip in formula auto complete as well as in the Manage Names dialog. 最后，我想說一個名稱對象的增強屬性——名稱注釋。名稱注釋可以用來闡述這個名稱指的是什么、可以做些什么或不可以做些什么等等。在用戶界面（新增/編輯名稱對話框）和OM中都可以編輯注釋，它將出現在Formula AutoComplete中名稱選項的提示和名稱管理對話框中。

Some Interesting uses of this field might include 名稱注釋可能包括如下的一些內容：

? Detailed description of a Names purpose ? 名稱用途的詳細描述 ? Name auditing (track changes, data refresh dates, etc) ? 名稱審核（修改記錄、數據更新日期，等等） ? General notes 一般性的注釋 ? Another thing we would be interested in hearing is how would you use the name comment feature. ? 希望您能喜歡名稱注釋這個功能。

That wraps up “Formula Editing Improvements Week”; I hope you found this interesting. Talk to you next week. 本周話題——“對編輯公式的改進”已近尾聲。我希望您能對此感到興趣。下周的事我們下周再說。

Published Friday, October 21, 2005 4:38 PM by David Gainer Filed Under: Formulas and functions

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。