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
| Feature | Where to find it on Mac | Windows location |
|---|---|---|
| PivotTable | Insert ▸ PivotTable | Insert ▸ PivotTable |
| Data Analysis ToolPak | Tools ▸ Excel Add-ins, then Data ▸ Data Analysis | File ▸ Options ▸ Add-ins |
| Solver | Tools ▸ Excel Add-ins, then Data ▸ Solver | File ▸ Options ▸ Add-ins |
| Power Query | Data ▸ Get Data (Power Query), where available | Data ▸ Get Data |
| Developer tab | Excel ▸ Settings ▸ Ribbon & Toolbar | File ▸ Options ▸ Customize Ribbon |
| VBA editor | Tools ▸ Macro ▸ Visual Basic Editor | Alt+F11 |
| Excel Options | Excel ▸ 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
Open Excel ▸ Settings ▸ Ribbon & Toolbar.
In the list of main tabs, tick Developer and save.
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.
