Office Settings & Configuration

Find Missing Name Manager and Use in Formula in Excel for Mac

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 868 views

Question details

Find the Name Manager and Use in Formula commands in Excel for Mac and identify alternatives if they are unavailable.

Find Missing Name Manager and Use in Formula in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user wants to create and use named cells, ranges, or formulas in an Excel workbook.
Observed behavior
The user cannot find Name Manager or Use in Formula among the defined-name tools.
Before you start

Open the workbook in the desktop Excel application on your Mac and select a cell or range you want to name. Command names and locations can vary by Excel version.

Solution 1Recommended

Find or restore the defined-name tools in Excel for Mac

Use this method to locate the commands or make the Formulas tab visible.

1
Open the Formulas tab

In Excel, select Formulas on the ribbon and look for the Defined Names section. Check for Name Manager, Define Name, or Use in Formula, depending on your version.

2
Expand the ribbon

Maximize the Excel window and expand the ribbon if it is collapsed. Select Formulas again and check whether additional commands are visible.

3
Check ribbon settings

Open Excel > Preferences or Settings > Ribbon & Toolbar. If Formulas is unchecked in the ribbon customization list, enable it and save the change.

4
Check the Mac menu bar

If Name Manager is not shown, look under Insert > Name > Define for a dialog where you can work with defined names.

Find or restore the defined-name tools in Excel for Mac
Commands vary by version: Excel for Mac may use different labels or menu locations from Excel for Windows. A separate Name Manager or Use in Formula button may not be available in every version.
Free Microsoft Office alternative

Work with named ranges in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files in WPS Spreadsheets and continue working with formulas and named ranges; check important workbook features after moving between applications.

Work with named ranges and formulas in WPS SpreadsheetsOpen and save Microsoft Excel formats, including XLSX and XLSUse a familiar ribbon interface that makes switching easierInstall a lightweight office suite with free spreadsheet tools
microsoft office alternative - wps office

Frequently Asked Questions

Where is Name Manager in Excel for Mac?

Check the Formulas tab for Defined Names or Name Manager. If the button is not available in your version, look for Insert > Name > Define in the Mac menu bar.

How do I use a named range if Use in Formula is missing?

Type the defined name directly into a formula. For example, enter =SUM(SalesTotal) in a cell if SalesTotal is an existing named range.

Why can't I see the Formulas tab?

The ribbon may be collapsed or the tab may be hidden. Expand the ribbon, then check Excel > Preferences or Settings > Ribbon & Toolbar and enable Formulas if needed.

Can I create a named range without opening a name dialog?

Yes. Select a cell or range, click the Name Box to the left of the formula bar, type a valid name without spaces, and press Return.