Paste Names

Inserts a defined named cell range at the current cursor's position.

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

To access this command...

Choose Sheet - Named Ranges and Expressions - Insert.

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.

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.