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.
