Excel 2021 MacOS

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.

Legal Information About Our Products

keys.express and keys.discount are online platforms for product keys. The product keys available in our shops for Windows and other software are inexpensive, secure, legal and come with an activation guarantee.

Below you will find the most important legal information about our products.

Unused and Non-Activated Product Keys

We offer exclusively unused and non-activated product keys. The keys have never been redeemed for activation and are fully available to the purchaser for the first-time activation of the respective product. A key that has already been redeemed could no longer be used for a new activation and is therefore not offered by us.

Trading in these product keys is permissible in the European Union and in Switzerland under current case law, provided that the necessary conditions are met. These conditions are as follows:

• The software must originally have been placed on the market with the consent of the rightholder within the territory of the EU, another contracting state of the EEA, or Switzerland by way of sale.
• The license for the software must have been granted in return for the payment of a fee intended to enable the rightholder to obtain remuneration corresponding to the economic value of the copy of the software.
• The rightholder must have granted the first acquirer the right to use the software permanently (for an unlimited period).
• Any improvements and updates that the subsequently downloaded computer program has compared to the originally downloaded one must be covered by a maintenance agreement concluded between the rightholder and the first acquirer.
• The original licensee must have made their own copies unusable.

This trade is legally permissible because the underlying license was already placed on the market with the consent of the rightholder within the EU/EEA or Switzerland in return for appropriate remuneration. As a result, the so-called principle of exhaustion has taken effect, which permits the resale of individual product keys — in particular those originating from volume license agreements. Microsoft or the respective software provider has already received appropriate remuneration for this.

keys.express and keys.discount ensure that the aforementioned conditions are met and that the lawful use of the software is guaranteed. The requirements arising from European legislation are also observed in Switzerland.

Important note: The acquisition of a product key through the transmission of a combination of numbers and letters in digital form does not, in itself, constitute a license for the lawful use of the program. The license only arises from the respective installation and the associated acceptance of the manufacturer's terms of use.

Further information can be found here:

• Legal assessment by Swiss lawyers

Overview of the Most Important Legal Information

• We offer unused, non-activated product keys for the activation of the respective computer programs. The key alone is not yet a license.
• The license only arises from the respective installation and the resulting acceptance of the terms of use. These terms of use govern the right to use the software between you and the respective manufacturer.
• The principle of exhaustion has, as a rule, taken effect — i.e. the license is "used up" — as soon as it was lawfully placed on the market for the first time. The products concerned are software placed on the market for unlimited-time use in the form of an activatable product key with the option to download the program. Microsoft or the respective software provider has received appropriate remuneration for this.
• You gain access to particularly attractively priced product keys from volume license agreements, which are to be treated legally in the same way as parts of volume licenses upon first acquisition.
• The software itself is always the same original software that is also obtained through official download channels or manufacturer sources. You are therefore not paying for a different or inferior version, but for a valid activation key or a corresponding license.
• All brand names and brand logos are registered trademarks, whose use here serves solely for product description — the ownership rights lie with the respective trademark holder.