The Paste List result includes all defined names with workbook scope, and name constants as shown by ② in figure 1. To resize the selection column width, press Home > Cells > Format > AutoFit Column Widthįig 1: Defined names from the Paste List process – with the defined Name Manager dialog activated.In the Paste Names dialog box, click the Paste List item.On the ribbon use the sequence Formulas > Defined Names > Use in Formula > Paste Names (the last item), or simply press the F3 short cut.Select the cell for the paste target, such as cell B5 in the example in figure 1.
To paste a list of defined names to a location in the current workbook, do the following:
