Exceljet

Quick, clean, and to the point

Define name using row and column labels

Windows shortcut 
CtrlShiftF3
Mac shortcut 
Fn⌃⇧F3

This shortcut displays the Create Names dialog box, which can be used to automatically name ranges based on row and column headings.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below show how this shortcut can be used.
Shortcuts for named ranges
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.