Named Ranges and Expressions

Allows you to name the different sections of your spreadsheet document. By naming the different sections, you can easily navigate through the spreadsheet documents and find specific information.

若要使用此指令...

From the menu bar:

Choose Insert - Named Range or Expression.

Choose Sheet - Named Range or Expression

Define Names

Opens a dialog where you can specify a name for a selected area or a name for a formula expression.

Manage Names

Opens a dialog where you can manage names in the spreadsheet.

Insert Name

Inserts a defined named cell range at the current cursor's position with the Paste Names dialog.

Create Names

允許您自動命名多個儲存格範圍。

Define Label Range

開啟一個對話方塊，您可以在其中定義標籤區域。