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 .
About This Shortcut
This shortcut will move focus to the name box , located above column A:
The current selection on the worksheet is unaffected, so you can use this shortcut to quickly select the name box and define a new named range . Alt + F3 works in Windows only and it appears to have been introduced in Excel 2016.
On the Mac there is no equivalent shortcut. However, you can use another shortcut, F6, to cycle through “panes”. It may take more than one click, but F6 will select the name box eventually.
