Paste list of defined names

Paste list

To paste a list of defined names to a location in the current workbook, do the following:

Select the cell for the paste target, such as cell B5 in the example in figure 1
On the ribbon use the sequence Formulas > Defined Names > Use in Formula > Paste Names (the last item), or simply press the F3 short cut
In the Paste Names dialog box, click the Paste List item. The list is now the selection
To resize the selection column width, press Home > Cells > Format > AutoFit Column Width

xlf-paste-list-def-names — **Fig 1: Defined names** from the Paste List process - with the defined Name Manager dialog box activated

The Paste List result includes all defined names with workbook scope, and name constants as shown by ② in figure 1. On the other hand, the worksheet scope item ① is not included in the Paste List items.

Note: Defined names are sometimes called "range names" in the language of Lotus 1-2-3.

Download a copy of the file shown in figure 1 fss20xx_1_ass1 [36KB]. No content, only defined names.
This example was developed in Excel 2013 Pro 64 bit.
Last modified: , [Australian Eastern Standard Time (AEST)]

Published: 16 March 2015
Revised: Saturday 25th of February 2023 - 10:13 AM, [Australian Eastern Standard Time (EST)]