F3 in Excel: Show all named ranges in Excel – via: Spreadsheet Audit & Maintenance Tip | Chandoo.org – Learn Microsoft Excel Online
Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.