Creating a list of all named ranges |
  
|
Creating a list of all named ranges |
|
You can instruct Calculate 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.