What is included in Microsoft Excel 2021 for Mac?

XLOOKUP and XMATCH – Exact-match lookups without nested INDEX and MATCH.
Dynamic arrays – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY functions.
LET function – Stores intermediate calculations inside a single formula.
Watch Window – Audits formula results across sheets and workbooks.
Core Capacity – Co-authoring on workbooks stored in OneDrive or SharePoint.
Important – This is a standalone application; the full Microsoft Office suite is not included.

Compare included Office programs from 2010 to 2024
To compare included applications, read our overview: full comparison of all Office versions from 2010 to 2024 and which programmes each one contains.

What are the main benefits of Microsoft Excel 2021 for Mac?

Excel 2021 for Mac is the 2021-generation desktop spreadsheet application for macOS, sold as a single app instead of a suite. It adds XLOOKUP, XMATCH, LET and dynamic array functions to the classic Excel workflow and receives security and quality updates until 13 October 2026.

One-time purchase – Classic desktop app instead of a subscription.
Modern lookup functions – XLOOKUP replaces fragile VLOOKUP and INDEX/MATCH chains.
Spilled array formulas – One formula fills a whole result range.
Faster recalculation – SUMIF, COUNTIF and AVERAGEIF calculate faster.
Apple silicon support – Runs natively on Apple silicon and Intel.
Offline work – Full spreadsheet editing without cloud storage.

What does Excel 2021 for Mac actually do in daily work?

It gives macOS users the full desktop calculation engine, not the reduced browser version of Excel. The practical gain over Excel 2019 for Mac sits in the formula bar: XLOOKUP returns exact matches by default, XMATCH returns the position of a value, and the dynamic array functions FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY spill results into neighbouring cells without an array-entry shortcut. LET assigns names to intermediate results inside one formula, so a lookup that used to be repeated four times in the same calculation is now written once. The Watch Window keeps selected cells and their formulas visible while you work in another sheet or workbook, which is the quickest way to audit a large model without jumping between tabs.

Get more out of Office for Mac
For practical Mac workflow tips, read our guide: the best tips and tricks for Office for Mac and how to get the most out of your software.

Who is Excel 2021 for Mac best suited for?

It suits Mac users who need the desktop formula engine and want a fixed version rather than a plan that keeps changing the interface: accountants, controllers, analysts, engineers and self-employed users who build their models locally. Buying the single app is the sensible route when the other suite programs would never be opened – there is no reason to install Word, PowerPoint and Outlook on a machine that only produces spreadsheets. Because co-authoring and change-saving run through files kept in OneDrive or SharePoint Online, it also works for people who share a workbook occasionally but keep the file on their own disk the rest of the time. It is the wrong tool for anyone whose reporting depends on Power Pivot or the Excel Data Model, because those components exist only in Excel for Windows.

How does Excel 2021 for Mac compare to Excel 2024 for Mac?

Both are one-time-purchase Mac releases with the same core interface, but Excel 2024 for Mac contains the formula and charting work Microsoft shipped after the 2021 release. The concrete additions are LAMBDA, the 14 new text and array functions (TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, EXPAND), pictures placed inside cells through the IMAGE function, and charts that follow a dynamic array as it grows or shrinks. The difference that decides most purchases is the support horizon: Excel 2021 for Mac reaches end of support on 13 October 2026, the 2024 release on 9 October 2029. The table below lists the verified differences.

How does Excel 2021 for Mac differ from Microsoft 365?

Excel 2021 for Mac is a fixed release that never gains new functions after installation, while Microsoft 365 keeps adding them. In practice that means LAMBDA, TEXTSPLIT, VSTACK, GROUPBY, PIVOTBY, Python in Excel and Copilot in Excel are Microsoft 365 features and are not part of the 2021 version, and no update will add them later. What the 2021 release does keep is co-authoring, modern comments and automatic saving for workbooks stored in OneDrive or SharePoint Online, so shared editing is not exclusive to the subscription. Choose Microsoft 365 if a report depends on Copilot-written formulas or Python analysis; choose the 2021 release if the priority is a formula set that behaves identically for years and no recurring cost.

Compare Office versions from 2010 to 2024
For help choosing the right Office version, read our guide: Office versions from 2010 to 2024 without a subscription and which one suits your system and budget.

Does Excel 2021 for Mac support Power Pivot, the Data Model and ActiveX?

No – Power Pivot and the in-memory Data Model are Windows-only and are not included in any Excel for Mac release, so imported data and PivotTables can only be loaded into worksheet tables, never into a model with relationships and DAX measures. ActiveX controls are equally unsupported on macOS: a workbook built on Windows with ActiveX buttons usually opens read-only or reports unsupported content, and those controls have to be rebuilt as Form controls or VBA UserForms. VBA macros themselves do run, but COM and VSTO add-ins do not, because Office for Mac runs sandboxed and uses the JavaScript-based Office Add-ins model instead. Anyone migrating a Windows reporting process to a Mac should test these three points first, since they cause more failed workbooks than any formula difference.

Do workbooks from Excel for Windows open correctly in Excel 2021 for Mac?

Yes – the file formats are identical, so .xlsx, .xlsm and the older .xls files open and save without conversion, and OpenDocument spreadsheets are supported as well. Problems come from platform components rather than the format itself: Power Pivot models, ActiveX controls and COM add-ins are the three things that will not follow a workbook from Windows to macOS. Formulas written with XLOOKUP, XMATCH, LET or the dynamic array functions calculate the same on both platforms, because Excel 2021 shares that function set across Windows and Mac. Charts and shapes can also be exported as SVG from the Mac version, which keeps diagrams sharp when they are reused in documents or presentations.

What should users check before choosing Excel 2021 for Mac?

First the date: Microsoft ends support for Office 2021 on 13 October 2026, with no extension and no extended security updates, so this is a short-horizon purchase rather than a long-term platform. Second, check existing workbooks for Power Pivot models, ActiveX controls or COM add-ins, none of which work on macOS. Third, check the functions your templates already use – if they contain TEXTSPLIT, VSTACK or LAMBDA, those cells will return an error here and the 2024 version is the correct choice. Finally, confirm that only the spreadsheet application is needed, because adding Word or PowerPoint later as separate single apps costs more than a suite version bought once.

Serializer keys for Office for Mac explained
For Mac-specific license details, read our guide: what you need to know about the serializer key for Office for Mac before you buy.

Frequently asked questions about Microsoft Excel 2021 for Mac

Are Word, PowerPoint or Outlook part of Excel 2021 for Mac?

No. This product is the spreadsheet application only, and the other Office programs are separate products. Users who need Word or PowerPoint on the same Mac should compare a suite version before buying single apps.

Is Excel 2021 for Mac a classic desktop version?

Yes. It installs locally on macOS and runs natively on both Apple silicon and Intel Macs, without streaming from a browser. Workbooks can be stored on the local disk; OneDrive and SharePoint Online are optional and only needed for co-authoring.

Is Excel LTSC 2021 for Mac the same product?

No. Excel LTSC 2021 for Mac is the commercial variant, and Microsoft confirms that co-authoring, modern comments, presence indicators, automatic saving and sheet views are not included in it. The formula features – XLOOKUP, XMATCH, LET and the dynamic array functions – are present in both.

Does Excel 2021 for Mac still work after 13 October 2026?

The application keeps opening and calculating after that date, but Microsoft stops delivering security updates, bug fixes and technical support for Office 2021. There is no paid extended-security programme for this version, so workbooks handled in regulated or client-facing environments should be planned onto a supported release before the deadline.

Does Excel 2021 for Mac receive new features over time?

No. One-time-purchase Office versions receive only security and quality updates, never new functionality. Functions introduced after the 2021 release, such as LAMBDA and the 14 text and array functions, remain exclusive to Excel 2024 and Microsoft 365.