Quick, clean, and to the point

Define name

Windows shortcut 
Mac shortcut 

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.

Related videos

The videos below demonstrate this shortcut.
What is an Excel Table? This video provides an introduction to Excel Tables.
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.