Creating a list of all named ranges

<< Click to Display Table of Contents >>

Creating a list of all named ranges

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

Proceed as follows:

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

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