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).
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.