Insert Name

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

note

You can only insert a cell area after having defined a name for the area.


To access this command...

From the menu bar:

Choose Insert - Named Ranges and Expressions.

Choose Sheet - Named Ranges and Expressions - Insert.

From the tabbed interface:

On the Insert menu of the Insert tab, choose Named Ranges and Expressions.


Table area

Lists all defined cell areas. Double-click an entry to insert the named area into the active sheet at the current cursor position.

Paste All

Inserts a list of all named areas and the corresponding cell references at the current cursor position.

Paste

Inserts the selected named area and the corresponding cell reference at the current cursor position.

Please support us!