Open the Name Manager
Windows shortcut
CtrlF3
Mac shortcut
Fn⌃F3
In Windows, this shortcut now displays the Name Manager dialog, where you can click the New button, to create a new name. There is no actual shortcut for to create a single new name, except through the ribbon: Alt M + MD
On a Mac, this shortcut displays the Define Name dialog box, which offers to name a range based on the current selection.
Related videos
The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.