In large worksheet models, it’s easy to accumulate a long list of defined names. To keep a
record of all the names used, you can paste a list of defined names in your worksheet by clicking
Paste List in the Paste Name dialog box. Excel pastes the list in
your worksheet beginning at the active cell.