Create named range from selection
Master this Excel shortcut with our comprehensive guide
Named Ranges Shortcuts
Ctrl + Shift + F3
⌘ + Shift + F3
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + F3
Instructions
1. Select the range of cells
2. Press Ctrl + Shift + F3
3. Opens dialog to automatically create a named range using row or column labels
2. Press Ctrl + Shift + F3
3. Opens dialog to automatically create a named range using row or column labels
Keyboard Shortcut
⌘ + Shift + F3
Instructions
1. Highlight cells
2. Press Command + Shift + F3
3. Automatically defines a name from selection
2. Press Command + Shift + F3
3. Automatically defines a name from selection
💡 Pro Tip: Use to quickly define names for ranges to make formulas clearer.
Quick Actions
More Named Ranges Shortcuts
Ctrl + F3