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

- 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.
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.
Find or restore the defined-name tools in Excel for Mac
Use this method to locate the commands or make the Formulas tab visible.
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.
Maximize the Excel window and expand the ribbon if it is collapsed. Select Formulas again and check whether additional commands are visible.
Open Excel > Preferences or Settings > Ribbon & Toolbar. If Formulas is unchecked in the ribbon customization list, enable it and save the change.
If Name Manager is not shown, look under Insert > Name > Define for a dialog where you can work with defined names.

Create and use a named range without Use in Formula
Use this workaround when you can define a name but cannot find the Use in Formula menu.
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.

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.




