Exceljet

Quick, clean, and to the point

Define name using row and column labels

Windows shortcut 
CtrlShiftF3
Mac shortcut 
FnF3

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.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.

Download 200+ Excel Shortcuts

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

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas