Named Ranges and Expressions

允許您命名試算表文件的不同區域。 透過命名不同區域,您可以輕鬆地瀏覽整個試算表文件,並尋找特定資訊。

若要使用此指令...

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

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

Please support us!