Insert Name

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

Вставить диапазон ячеек можно только после присваивания имени этому диапазону.

Доступ к этой команде

Choose Insert - Named Ranges and Expressions.

Choose Sheet - Named Ranges and Expressions - Insert.

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.

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.