Display List of Named Ranges
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.
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
Leave a comment
| Trackback


