Windows Mac
CtrlF3 Fn⌃F3

About This 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 to create a single new name, except through the ribbon: Alt M + MD

On a Mac running Excel 365, the shortcuts fn + Control + F3 and fn + Command + F3 both open the Name Manager. In older Mac versions, fn + Control + F3 displays the Define Name dialog box, which offers to name a range based on the current selection.

Related videos

Excel What is an Excel Table

What is an Excel Table

In this video, we'll introduce the idea of an Excel Table. So, what is an Excel Table? An Excel table is a rectangular range of data that has been defined and named in a particular way. To illustrate, here I have two rectangular ranges of data. Both ranges contain exactly the same data but neither …
Excel Shortcuts for named ranges

Shortcuts for named ranges

In this video, we'll look at shortcuts for creating and applying named ranges. Here we have a set of sales data that spans 2 years, broken down by month. Using named ranges, I'm going to add several formulas to fill in the summary information, based on a name in I8. Generally, the fastest way to …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.