Exceljet

Quick, clean, and to the point

Select name box

Windows shortcut 
AltF3

This shortcut will move focus to the name box, located above column A:

Excel shortcut to move focus to the name box

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. F3 works in Windows only. However, on the Mac 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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.