Where Is It in Excel for Mac? PivotTable, Data Analysis, Solver, Power Query and the Developer Tab

Quick answer: In Excel for Mac, PivotTable is on the Insert tab, Data Analysis and Solver are add-ins you switch on from Tools ▸ Excel Add-ins, the Developer tab is enabled in Excel ▸ Settings ▸ Ribbon & Toolbar, and Options from Windows is Excel ▸ Settings (Preferences in older versions).

If you moved from Windows, many features did not disappear. They moved to the Mac menu bar. Here is where each one lives.

Where each feature is

FeatureWhere to find it on MacWindows location
PivotTableInsert ▸ PivotTableInsert ▸ PivotTable
Data Analysis ToolPakTools ▸ Excel Add-ins, then Data ▸ Data AnalysisFile ▸ Options ▸ Add-ins
SolverTools ▸ Excel Add-ins, then Data ▸ SolverFile ▸ Options ▸ Add-ins
Power QueryData ▸ Get Data (Power Query), where availableData ▸ Get Data
Developer tabExcel ▸ Settings ▸ Ribbon & ToolbarFile ▸ Options ▸ Customize Ribbon
VBA editorTools ▸ Macro ▸ Visual Basic EditorAlt+F11
Excel OptionsExcel ▸ Settings (Preferences)File ▸ Options

Exact labels vary slightly between Excel versions, so use the feature name as your anchor.

PivotTable

Select your data, open the Insert tab, and choose PivotTable. A full walkthrough, including the keyboard route, is in Complete Guide to Pivot Tables in Excel for Mac, and the shortcuts are in What Are the Pivot Table Shortcuts on Mac?.

Data Analysis and Solver

These are add-ins. Open Tools ▸ Excel Add-ins, tick Analysis ToolPak and Solver Add-in, and click OK. Data Analysis and Solver then appear on the Data tab.

Power Query

Recent Microsoft 365 builds of Excel for Mac include Data ▸ Get Data (Power Query). Availability depends on your Excel version, so if you cannot see it, update Excel from Help ▸ Check for Updates.

Developer tab and VBA

  1. Open Excel ▸ Settings ▸ Ribbon & Toolbar.

  2. In the list of main tabs, tick Developer and save.

  3. The Visual Basic Editor is under Tools ▸ Macro ▸ Visual Basic Editor. Option+F11 opens it from the keyboard (hold Fn if function keys are not standard).

Keyboard shortcuts for the features above

A few of these features have documented shortcuts in Excel for Mac, which helps if you like to stay on the keyboard:

  • Option+F11: open Visual Basic.

  • Option+F8: display the Macro dialog box.

  • Option+F12: open the Power Query Editor.

  • Shift+F3: open the Formula Builder, the Mac version of the Insert Function dialog.

  • Cmd+F3: open the Define Name dialog box.

Function keys may need Fn depending on your keyboard setting.

Customising the Ribbon

If a command you rely on is not where you expect it, you can add it yourself. In Excel, Settings, Ribbon and Toolbar you can show or hide whole tabs, add commands to a custom group, and tick the Developer tab. That is also where the Quick Access Toolbar settings live, so it is worth a look when moving from Windows.

If a feature seems to be missing entirely

Three things explain most cases. The feature may be an add-in that is switched off, such as the Analysis ToolPak or Solver. It may depend on your Excel version, which is common for Power Query features. Or it may exist on Windows only. Check Help, Check for Updates first, because newer builds regularly add features to the Mac version.

Differences worth knowing

Not every Windows feature exists on a Mac, and the Ribbon can differ. For the bigger picture see Excel for Mac vs Excel for Windows: What's Actually Different in 2026?, and for shortcuts see Complete Mac Excel Shortcut Cheat Sheet: Ribbon, Mouse and Mac Excel Shortcuts.

FAQs

Where is the Data Analysis ToolPak in Excel for Mac?

Turn it on in Tools ▸ Excel Add-ins, then look on the Data tab.

Where are Options in Excel for Mac?

Excel ▸ Settings, called Preferences in older versions.

Does Excel for Mac have Power Query?

Current Microsoft 365 versions do, under Data ▸ Get Data.

Where is the Macro dialog in Excel for Mac?

Use Tools, Macro, Macros, or press Option+F8.

How do I open Visual Basic from the keyboard?

Press Option+F11, holding Fn if your function keys are not set as standard.

How do I add a missing command to the Ribbon?

Open Excel, Settings, Ribbon and Toolbar, and add the command to a tab or a custom group.

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.