Get a list of all defined named ranges
Master this Excel shortcut with our comprehensive guide
Named Ranges Shortcuts
F3
⌘ + F3
How to Use This Shortcut
Keyboard Shortcut
F3
Instructions
1. Press F3
2. Opens the 'Paste Name' dialog box with all defined named ranges
3. Select a name to quickly navigate or insert
2. Opens the 'Paste Name' dialog box with all defined named ranges
3. Select a name to quickly navigate or insert
Keyboard Shortcut
⌘ + F3
Instructions
1. Press Command + F3
2. Displays a list of all named ranges for easy selection
2. Displays a list of all named ranges for easy selection
💡 Pro Tip: Quickly locate named ranges without scrolling through large spreadsheets.
Quick Actions
More Named Ranges Shortcuts
Ctrl + Shift + F3
Ctrl + F3