Listing names

You can paste a list of the names and ranges they refer to into a worksheet. To do this, move to a blank cell with plenty of blank cells below it and one free column to its right, and select Insert, Name, Paste, Paste List. You will get a two-column list with the names in the first column and the cells to which they refer to their right.