Exceljet

Quick, clean, and to the point

Define name

Windows shortcut 
CtrlF3
Mac shortcut 
FnF3

In Windows, this shortcut now displays the Name Manager dialog, where you can click the New button, to create a new name. There is no actual shortcut for to create a single new name, except through the ribbon: Alt M + MD

On a Mac, this shortcut displays the Define Name dialog box, which offers to name a range based on the current selection.

Just a fantastic site. I have learned a ton in a short period. Your videos shaved about 4 hours off an assignment for work this past week. -Kurt
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