Excel for Mac vs Excel for Windows: What's Actually Different in 2026?

Whether Excel for Mac is the same as Excel for Windows has changed in recent years. Power Query, Python in Excel, Copilot and a basic version of Ribbon KeyTips have all reached the Mac, but some gaps remain, and if your job depends on one of them, nothing else in the comparison matters.

This guide is for people deciding whether a Mac will work for an Excel-heavy job, or who have just switched and want to know what to expect.

Quick answer: For everyday spreadsheet work (formulas, PivotTables, charts, tables, XLOOKUP) Excel for Mac is close to Windows. Microsoft documents these gaps: no Power Pivot or Data Model, no ActiveX controls, no third-party COM add-ins on its Office 2016 for Mac page, and fewer Power Query data sources. Keyboard shortcuts also differ: Command replaces Ctrl, function keys need Fn, and KeyTips did not run Alt sequences end to end in our tests.

How we checked: Microsoft does not publish one current Windows-versus-Mac comparison that we could find, so each row below was checked against Microsoft's page for that feature, opened on November 3, 2026. Where Microsoft says nothing, the row says so. The keyboard results come from our own tests on macOS 26.5 and Excel 16.114.1.

What is actually different between Excel for Mac and Excel for Windows?

The differences cluster in five areas: keyboard shortcuts, Power Query sources, Power Pivot, VBA and add-ins. The matrix below lists each feature with its status on Mac and the Microsoft page that supports it.

Four-column chart of Excel for Mac against Windows. Same on both: formulas, PivotTables, charts, Analysis ToolPak. Limited on Mac: Power Query sources, VBA macros, Python in Excel, KeyTips. Not on Mac: Power Pivot and the Data Model, ActiveX controls, third-party COM add-ins. Unconfirmed: Forecast Sheet, 3D Maps, Inquire and Spreadsheet Compare.
Where each feature stands on Mac, grouped by status. Microsoft documents the Not on Mac group; the Unconfirmed group has no clear Microsoft statement.

Status is for Microsoft 365 (subscription) Excel. Perpetual versions such as Excel 2021 or 2024 for Mac generally get fewer new features.

FeatureWindowsMacWhat it means in practiceSource and status
Formulas, dynamic arrays, XLOOKUPYesYesNo meaningful difference reportedConsensus of comparison guides; no Microsoft comparison page
PivotTables and chartsYesYesWork on bothConsensus of comparison guides
Keyboard shortcutsCtrl-basedCommand-based, some ControlThe biggest daily adjustmentMicrosoft Excel shortcut list
Ribbon KeyTipsOn by defaultVersion 16.89 and later, off by defaultAlt sequences did not finish in our testsMicrosoft ribbon page plus our test on macOS 26.5, Excel 16.114.1
Power Query editorYesYes, Microsoft 365 version 16.69 or laterShaping works; Microsoft's page also says authoring is not availableMicrosoft Power Query for Mac page
Power Query sourcesManyWorkbook, Text/CSV, XML, JSON, SharePoint Online lists, OData; SQL Server in Insiders Beta onlyFrom Web is not listed; ODBC and Microsoft Query are separate Data menu commandsMicrosoft Power Query for Mac page
Power Pivot and Data ModelYesNoThe biggest gap for analysts and BI usersMicrosoft: Turn on Power Pivot
VBA macrosYesMost objects work; file access is sandboxedUse AppleScriptTask instead of MacScriptMicrosoft Learn: VBA for Office for Mac
ActiveX controlsYesNoUse Form controls insteadMicrosoft: Assign a macro to a Form or Control button
Third-party COM add-insYesNot supported on Office 2016 for MacCheck each vendor for Mac supportMicrosoft Learn: VBA for Office for Mac
Analysis ToolPakYesYes, under Tools, Excel Add-insSolver is not covered on that pageMicrosoft: Load the Analysis ToolPak
Python in ExcelYesBusiness and Enterprise: Current Channel from 16.96; Family and Personal: Beta previewDepends on your planMicrosoft: Python in Excel availability
Forecast SheetYesNo Microsoft statement foundMicrosoft's page is titled for Windows; FORECAST.ETS functions are separateMicrosoft: Create a forecast in Excel for Windows
3D MapsYesNo Microsoft documentation of Mac supportMicrosoft community answers say Windows onlyMicrosoft Q&A, 2019 and 2022 replies

Which keyboard shortcuts change on Excel for Mac?

Command replaces Ctrl for most shortcuts, function keys need Fn on a MacBook, and Alt sequences did not run end to end in our tests. The sections below cover each change.

Does Command replace Ctrl on Excel for Mac?

Mostly, yes: ⌘C, ⌘V, ⌘Z, ⌘S and ⌘F match Windows with Command in place of Ctrl. Excel for Mac also keeps some Control shortcuts, and Microsoft says many Ctrl shortcuts work with Control.

Some shortcuts split the two keys: ⌃; inserts the date, but ⌘; inserts the time, and ⌃U edits a cell, but ⌘U underlines. Our Ctrl key on Mac guide has the full list of exceptions.

Why do function keys need Fn on a MacBook?

On a MacBook the top row controls brightness, volume and media first, so F2, F4 and F9 reach Excel only with Fn or after changing the Function Keys setting in System Settings.

Turn on Use F1, F2, etc. keys as standard function keys in System Settings ▸ Keyboard, or hold Fn (or the Globe key). Excel also gives several of them Mac-friendly alternatives:

WindowsMac alternative
F2 (edit cell)⌃U
F4 (toggle $ references)⌘T
F4 (repeat last action)⌘Y
F9 (calculate)⌘=
F5 / Ctrl+G (Go To)⌃G

Do Alt sequences work on Excel for Mac?

Not end to end in our tests. Microsoft documents KeyTips from version 16.89, off by default, but Alt, E, S, V did not complete on Excel 16.114.1 or on earlier builds.

On Windows, pressing Alt shows letters on the Ribbon so you can run any command from the keyboard: Alt, H, V, V to paste values, Alt, H, M, C to merge and centre. That is how many finance professionals work.

Excel for Mac documents its own KeyTips from version 16.89, switched off by default under Preferences ▸ Accessibility ▸ KeyTips. In our tests on macOS 26.5, KeyTips did not work at all on Excel 16.114.1, and on earlier builds they opened a dialog but the sequence could not be finished from the keyboard. Results may differ on your build.

The Mac Excel Shortcuts app targets this exact gap, and we make it. It ran Alt, E, S, V and other shortcuts end to end in our test on the same setup. For free options and the Mac routes, see our Alt key guide and how to make Excel shortcuts work on Mac without relearning them.

Does Excel for Mac have Power Query?

Yes. Power Query shaping is available to Microsoft 365 subscribers on Excel for Mac version 16.69 or later, with a shorter list of data sources than Windows.

Microsoft's Mac page lists these import sources: Excel workbooks, Text/CSV, XML, JSON, SharePoint Online lists, OData and blank queries, plus SQL Server, which it says can be imported only in Insiders Beta. From Web is not listed. ODBC is not a Power Query source on Mac, but Data ▸ From SQL Server ODBC and Data ▸ From Database (Microsoft Query) offer separate paths, and the second needs an ODBC driver installed on the Mac.

What this means if you share files: a query built on Windows from a web page or another unlisted source may not refresh on a Mac. The data already loaded into the sheet stays, but you cannot update it. Microsoft's page also contradicts itself on authoring in the editor, saying shaping is generally available but authoring is not, so test your own queries.

Does Excel for Mac have Power Pivot and the Data Model?

No. Microsoft says Power Pivot is not currently available on Excel for Mac and suggests the Power Query editor for data gathering and shaping instead. Realistic options are Windows Excel, Power BI, or a rebuild.

  1. Run Windows Excel in a virtual machine such as Parallels Desktop; see our Parallels vs Boot Camp comparison.

  2. Move the model to Power BI, whose web service works from a Mac browser.

  3. Rebuild with lookups and dynamic arrays (XLOOKUP, FILTER, SUMIFS) if the model is simple enough.

For many people the gap stops there. If you do not use Power Pivot today, you will not miss it.

Do VBA macros run on Excel for Mac?

Mostly. Microsoft says most of the objects available in VBA for Office also work on Mac, but Office 2016 for Mac apps are sandboxed, which affects macros that access files or other processes.

  • ActiveX controls do not work: Microsoft states they are not supported on the Mac. Form controls work and are the safer choice for shared files.

  • Windows API calls and COM objects such as Declare statements, FileSystemObject and Scripting.Dictionary are commonly reported to fail on Mac. Microsoft's Mac VBA page does not list them, so test your code.

  • Hard-coded paths like C:Reports break. Build paths from Application.PathSeparator or ThisWorkbook.Path.

  • Sandboxing means macros may need permission to reach files, which Microsoft addresses with GrantAccessToMultipleFiles. MacScript is deprecated, and Microsoft recommends AppleScriptTask.

If you write macros that other people will run, test them on both platforms before rolling them out.

Do Excel add-ins work on Mac?

Office add-ins from the Office Store work on both platforms, but third-party COM and VSTO add-ins are Windows-only. Microsoft says Office 2016 for Mac does not support third-party COM add-ins.

  • Office add-ins (web-based, installed from Insert ▸ Get Add-ins) are built to run on both platforms.

  • COM and VSTO add-ins (installed with a Windows setup program) only work on Windows. That covers many bank and consultancy toolkits and older modelling tools.

Before switching, list the add-ins you use every week and check each vendor's Mac support. For finance teams that is usually the deciding factor. Microsoft documents loading the Analysis ToolPak on Mac under Tools ▸ Excel Add-ins; that page does not cover Solver.

Is Python in Excel available on Mac?

Yes, on some plans. Microsoft says Python in Excel is available to Enterprise and Business users on the Current Channel from version 16.96, and in Beta Channel preview for Family and Personal users.

Microsoft gives version 16.95 as the start of the Family and Personal preview. Its page carries no date, so check it before relying on the rollout.

What changes when Excel files move between Mac and Windows?

Files carry small surprises across platforms: column widths shift with fonts, the 1904 date system can move dates by four years, CSV encoding can garble accents, and Windows-only features stop working.

  • Column widths and row heights drift. Fonts render slightly differently on each system, so a print layout fitted on Windows may cut off text on a Mac. Leave breathing room in printed reports.

  • The 1904 date system. Very old Mac workbooks may use it. Copying dates between a 1904 workbook and a normal one shifts them by four years and one day. Check under Excel ▸ Preferences ▸ Calculation; Microsoft explains the date systems.

  • CSV encoding. Save as CSV UTF-8 on both platforms. Older formats can garble accented characters, so é becomes é.

  • Windows-only features in shared files. ActiveX buttons do nothing on the Mac side, and queries built on unlisted sources may not refresh.

Where is Excel for Mac better than Windows?

A few things are nicer on a Mac, based on our experience: custom shortcuts for almost any command, a searchable menu bar, trackpad navigation and Apple silicon battery life. We did not benchmark these.

  • Custom shortcuts for anything. Tools ▸ Customize Keyboard lets you put a shortcut on almost any command, such as Merge & Center, Wrap Text or Freeze Panes.

  • Searchable menu bar. Every command is also in the macOS menu bar, and Help ▸ Search (⇧⌘/) finds commands by name.

  • Trackpad navigation. Two-finger scrolling and pinch-to-zoom make big sheets easy to move around.

  • Battery life. Apple silicon laptops get through long modelling sessions on battery.

Should you switch to a Mac for Excel work?

Switching works if you build models with formulas, tables and PivotTables. It is risky if you depend on Power Pivot, ActiveX controls, COM add-ins or Windows Alt-key sequences.

Flowchart of four checks for whether Excel for Mac fits a job: Power Pivot or the Data Model, ActiveX or COM add-ins, Power Query sources outside the Mac list, and Windows Alt-key sequences; a yes to any leads to a workaround, four noes mean a good fit
Four checks decide whether a Mac will work for an Excel-heavy job: Power Pivot, ActiveX and COM add-ins, Power Query sources, and Alt-key sequences.
If you mainly...Excel for Mac is...
Build models with formulas, tables and PivotTablesA good fit; learn the shortcut differences and you are set
Rely on Alt-key Ribbon sequencesHard going; sequences did not run end to end in our tests, so plan for a shortcut tool or the Mac routes
Use Power Query on workbooks, text files, JSON or SharePointWorks
Pull data from the web or other sources outside the Mac listLimited; check the supported sources first
Use Power Pivot or DAXNot available; plan on Windows Excel or Power BI
Depend on third-party COM add-insNot supported on Microsoft's Mac VBA page; check the vendor
Share macro-heavy workbooks with ActiveX controlsNot supported; rebuild with Form controls first

FAQs

Is Excel for Mac as good as Excel for Windows?

For most everyday work, yes. The specific gaps are Ribbon Shortcuts, Power Pivot, ActiveX controls, COM add-ins and some Power Query sources, which matter mainly to power users and finance teams.

Do Excel files from Windows open on a Mac?

Yes. .xlsx, .xlsm and .xlsb files open normally. Windows-only features inside them, such as ActiveX controls, will not work, but the data and formulas will.

Can I use Windows Excel shortcuts on a Mac?

Not as-is. Most Ctrl shortcuts become Command shortcuts, and KeyTips did not run Alt sequences such as Alt, E, S, V end to end in our tests. See our guide to Windows shortcuts on Mac.

Does Excel for Mac have Power Query?

Yes. Microsoft documents the Power Query editor for Microsoft 365 on Mac from version 16.69, with fewer sources than Windows. From Web is not on its list, and SQL Server is Insiders Beta only.

Does Excel for Mac have Forecast Sheet or 3D Maps?

We could not confirm either from Microsoft documentation. Its Forecast Sheet page is titled for Windows and its 3D Maps page names no platform, while Microsoft community answers say 3D Maps is Windows-only.

Is it worth running Windows on a Mac just for Excel?

Only if you need something Mac Excel cannot do, such as Power Pivot or a Windows-only add-in. For shortcut muscle memory alone, a lighter fix is usually enough; see our Parallels vs Boot Camp comparison.

Sources

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