Quick, clean, and to the point

Select name box

Windows shortcut 

This shortcut will select the name box 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. This is Windows only – we don't know of a similar shortcut on the Mac.

Download 200+ Excel Shortcuts

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