Display List of Named Ranges

January 2nd, 2005 | Categories: Shortcuts | Tags:

If you work with Named Ranges, having the ability to view a list of your Named Ranges in a worksheet can sometimes be useful. Here are two ways to do so:

F3
Pressing the F3 Key will give you a list of Named Ranges. Selecting a named range in this view will PASTE the named range into your Formula.

F5
Pressing the F5 Key will also give you a list of Named Ranges. However in the F5 view selecting a range will GOTO that range.

No comments yet.