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

Comments welcome! Read this before posting a question.

I really appreciate your delivery of the videos, the clean and sharp documentation and pleasant to the eye website, uncluttered, direct, short and snappy. From what I've checked out elsewhere nothing compares... - Christina

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables