Insert Name

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


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

Til að nálgast þessa skipun...

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.


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

Please support us!