<< 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 . |
A list of all named ranges will now be inserted into the worksheet.