About This Shortcut
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 to create a single new name, except through the ribbon: Alt M + MD
On a Mac running Excel 365 , the shortcuts fn + Control + F3 and fn + Command + F3 both open the Name Manager. In older Mac versions, fn + Control + F3 displays the Define Name dialog box, which offers to name a range based on the current selection.
About This Shortcut
This shortcut displays the Create Names dialog box, which can be used to automatically name ranges based on row and column headings. You can also use the name box to define a name based on an existing selection. There is also a shortcut to open up the name manager .
