Creating a list of all named ranges

<< Click to Display Table of Contents >>

Creating a list of all named ranges

PlanMaker can insert a list of all named ranges into the worksheet. This is useful if you want an overview of all named ranges in the workbook and the corresponding cell addresses.

To do so, proceed as follows:

1.Select the cell where the list is to be inserted.
2.Choose the ribbon command Formula | group Named area | Export names export_names_icon.

A list of all named ranges will now be inserted into the worksheet.