Microsoft Office 2019 vs 2021: Key Differences and Upgrade Benefits

Office 2019 vs 2021 comes down to Excel and teamwork: the 2021 release adds XLOOKUP, LET and dynamic arrays, plus co-authoring and a new look, on the same one-time license. Office 2019 vs 2021 in practice: two desks in one small office. One PC runs Office 2019, the other Office 2021. The same workbook shows numbers on one screen and errors on the other. Same DOCX and XLSX files, same apps. We’d say the Excel underneath is what differs.

• Excel 2021 adds XLOOKUP, XMATCH, LET and dynamic arrays.
• Retail 2021 brings real-time co-authoring and modern comments.
• Both run on Windows 10 and Windows 11.
• No upgrade path: 2021 needs its own license.

That gap comes down to a handful of Excel functions, co-authoring and a new look. This pair gets compared a lot, so here’s what really changed.

Both are perpetual releases. Our Office 2019 and Office 2021 pages list the editions for each.

Buying today, we’d skip both and take Office 2024.

Office 2019 and Office 2021 side by side

The older release arrived in September 2018. It was a snapshot of what Office 365 subscribers had at the time.

The newer one followed on October 5, 2021, the same day as Windows 11. It captured another three years of subscription features.

Neither gets new features after release. You get the feature set you buy.

The app lineup and the one-time license stayed the same.

Office 2019 vs 2021: what’s new, app by app

Most of the gains sit in Excel and in teamwork. The list below follows Microsoft’s What’s new in Office 2021 page.

Excel

Excel is where the upgrade shows.

A common myth: LAMBDA isn’t part of Excel 2021. It came later to Microsoft 365 and then to Excel 2024, together with TEXTSPLIT and VSTACK.

If a guide promises LAMBDA in the 2021 release, it’s wrong.

Word

• Real-time co-authoring, modern comments and co-author presence, for documents stored on OneDrive or SharePoint.
• Dark Mode with a dark page, and not just a dark ribbon.
• Line Focus for reading one, three or five lines at a time.
• AutoSave for files in OneDrive or SharePoint, and OpenDocument 1.3 support.

PowerPoint

• Record Slide Show with presenter video, ink and laser pointer.
• Ink Replay and Rewind animations for pen drawings.
• A reading order pane for screen reader users, and links to specific slides.

Outlook

• Translator for messages in more than 70 languages.
• An Instant Search box above the ribbon.
• Ink annotations on images and a drawing canvas.

Access, Visio and the rest of the suite

Smaller changes, same Microsoft list.

• Access 2021: a Linked Table Manager to refresh, relink or remove linked tables. Plus Date/Time Extended. Handy for database people.
• Visio 2021: new Azure and AWS stencils and shapes. Visio is sold on its own, see our Visio Professional 2021 key.
• The three main apps share ODF 1.3 and an updated Draw tab. The Accessibility Checker got better too.
• Most apps: Microsoft Search at the top of the window, new stock media, a custom color picker and performance work.

None of that changes the verdict. Excel still carries the upgrade.

Who notices the difference

Retail and LTSC look different

Office LTSC 2021 comes as the volume license version for businesses. It skips co-authoring, modern comments, Sheet Views and the visual refresh. If a coworker’s Office 2021 looks different from yours, check whether one of you is on LTSC.

This mix-up is a common one. Two people compare screens and assume one install is broken. It isn’t.

Windows 11 and Mac

Both versions run on Windows 11 and on Windows 10. Microsoft’s Office and Windows configuration matrix lists both for those systems.

The 2019 release has near-identical requirements.

Older articles claim Office 2019 doesn’t work on Windows 11. That was never true.

Office 2019 vs 2021 on a Mac

Same idea on macOS: same file formats, same one-time license, a few extras in 2021.

Editions and keys for each sit on our Office 2021 for Mac and Office 2019 for Mac pages.

On a Mac, Office 2021 ran on the three most recent macOS versions at any given time. We’d keep it updated through Microsoft AutoUpdate. Microsoft explains how on its page about updating Office on macOS.

Is the upgrade from Office 2019 to 2021 worth it

In 2026, a move from 2019 to 2021 makes little sense. If you’re leaving 2019, we’d go straight to Office 2024.

You get every 2021 feature there, plus LAMBDA and newer Excel functions. Keep the 2021 suite only if it’s already installed.

Back when both were new, the answer depended on Excel. People who lived in spreadsheets got real value from XLOOKUP and dynamic arrays.

People who mostly wrote letters in Word and checked mail in Outlook barely noticed a difference.

A sensible order back then: finance PCs first, the rest later.

There’s no discounted upgrade between perpetual versions. Each one needs its own license and its own product key. None of them upgrades in place to the next.

Need a key? Our Office LTSC Professional Plus 2024 key comes as a genuine license. We email it instantly after payment.

Which one to keep or choose

If you already own both, keep the newer one. It has the newer Excel functions. For a new purchase, we’d choose neither.

The 2019 suite makes sense only on an offline PC where it’s already installed and licensed.

How to move from Office 2019 to a newer version

Plan a little time per PC. Most of it goes on the backup and the add-ins.

1. Back up custom templates, custom dictionaries and macros. Note where the Outlook data file lives.
2. Note which add-ins you use. Check that each has a version for the new Office.
3. Uninstall Office 2019 from Settings, Apps. Two Click-to-Run versions shouldn’t sit side by side.
4. Install the new version from the Microsoft download link for your key. Choose 64-bit unless an old add-in needs 32-bit.
5. Activate with your product key and sign-in. Then confirm under File, Account.
6. Restore templates and dictionaries. Then open your critical workbooks and documents, and check the macros.

As a rule, 64-bit is the default.

Our Office 2021 installation guide walks through the setup screens. They look the same for Office 2024.

Before you uninstall, open Excel and note the build number under File, Account, About Excel. That number helps when a workbook behaves differently after the move. It tells support which version you came from.

Common mistakes with Office 2019 vs 2021

• Expecting a free upgrade from 2019. There isn’t one.
• Looking for LAMBDA in Excel 2021. It arrived with Excel 2024.
• Comparing a retail screen with an LTSC screen. They look different by design.
• Installing the new suite next to the old one. Uninstall first.
• Sending a workbook with XLOOKUP to a 2019 user. They’ll see errors, not numbers.
• Believing the old claim that 2019 won’t run on Windows 11. It does.

Related guides

• Microsoft Office 2021 Home & Business vs. Professional

Terms used on this page

Typical mix-ups between the two versions

The formula that worked on one PC

A finance lead builds a sheet with XLOOKUP on a 2021 machine. A colleague on 2019 opens it and sees errors. Nothing is corrupt. The older Excel just lacks the function.

The suite that looked different

Two people both see “2021” under File, Account. One has the rounded new ribbon, the other the old look. One install is retail, the other LTSC.

The LAMBDA hunt

Someone follows a tutorial and types a LAMBDA formula in Excel 2021. Excel rejects it. The function came with Excel 2024.

The side-by-side install

A user installs the new suite without removing 2019. File types open in the wrong app. After a clean uninstall and a restart, the new version installs normally.

Versions and systems this guide covers

Office 2019 vs 2021: the short verdict

Own both? Keep the newer one. Buying new? Take Office 2024.

An offline PC with the 2019 suite already on it can stay as it is. Nobody has to rush that one.