Latest Excel Version: The Complete 2026 Guide to Microsoft 365, Excel 2026, and What's New for Power Users

Figuring out the latest Excel version in 2026 is more confusing than it should be, largely because Microsoft sells the spreadsheet under two parallel tracks: the perpetual Excel 2024 license you buy once, and the continuously updated Excel for Microsoft 365 subscription that gains new features every month. Both are technically current, both share most of the same calculation engine, and both run on Windows 11, macOS Sonoma, and modern browsers. Choosing between them depends on whether you want stability or a stream of cutting-edge tools.

For most knowledge workers, the latest Excel version means Microsoft 365 Apps for Enterprise build 17628 or newer, which now includes Python in Excel as a generally available feature, the redesigned Copilot pane, native support for the new PIVOTBY and GROUPBY functions, and the long-awaited focus cell mode that highlights the active row and column. Excel 2024, released in October 2024 and still supported through October 2029, is the perpetual sibling that locks in those features as of its release date but does not receive future functional updates.

This guide breaks down every version Microsoft currently supports, what each one costs, which features arrived in the last twelve months, and how to decide whether upgrading is worth the effort for your team. Whether you are a student weighing Excel 2024 Home & Student against a 365 Personal subscription, an analyst who depends on PowerQuery refresh speed, or an IT admin building a five-year licensing plan, the breakdown below covers what actually changed and what only marketing pretends changed.

You will also see how the latest Excel version handles tasks that used to require add-ins or third-party tools, including regex matching inside formulas, image references that behave like first-class values, and check boxes that finally return TRUE or FALSE instead of acting as floating shapes. Each of these additions matters because they replace workarounds people have used for two decades, and they change how interview questions about Excel are phrased on certification exams.

Before we dig in, it helps to anchor expectations. Microsoft has not released a brand-new perpetual version since Excel 2024, and there is no public roadmap promising Excel 2027. The company has clearly shifted its R&D budget toward Microsoft 365 and Copilot integrations, which means the latest Excel version, in practical terms, is whichever channel you are subscribed to. Perpetual licenses still exist, but they exist as a fallback for organizations that cannot or will not move to a subscription model.

If you want a hands-on way to test whether your current install behaves like the 2026 release, our Excel Functions List: The Complete Reference Guide to Every Formula You Need in 2026 walks through every formula introduced since Excel 2019, including the dynamic-array additions that quietly broke a generation of VLOOKUP templates. Use it as a quick compatibility check before you decide whether an upgrade is worth your time.

By the end of this article you will know exactly which Excel build you are running, what features your current license unlocks, what the next twelve months of updates will likely bring, and how to communicate the differences to colleagues who still call any spreadsheet program "Excel 2010." That clarity alone tends to pay for an upgrade within the first quarter you use it.

The single biggest decision when choosing the latest Excel version is whether you want Excel 2024 or Microsoft 365. On the surface they look nearly identical, with the same ribbon, the same file format, and the same calculation engine. Underneath, the difference is enormous: Excel 2024 is frozen at its October 2024 feature set, while Microsoft 365 keeps shipping new functions, performance improvements, and AI features for as long as your subscription is active. Over a five-year horizon, that gap widens dramatically.

Excel 2024 is a one-time purchase priced at $159.99 in the United States, and it installs on one Windows PC or one Mac. It does not include OneDrive cloud storage, real-time co-authoring is limited, and there is no Copilot pane. You will not get Python in Excel, you will not get the new REGEX family of functions, and you will not see the focus cell feature unless Microsoft retroactively ports it, which the company has explicitly said it will not do for most additions.

Microsoft 365 Personal runs $99.99 per year and includes Excel along with Word, PowerPoint, Outlook, 1 TB of OneDrive storage, and Copilot Pro credits in the Family tier. For most households the math works in favor of the subscription within the first two years, especially if multiple family members need the apps. The Family plan, at $129.99 per year, covers up to six people on multiple devices, which makes it dramatically cheaper per seat than perpetual licensing.

For businesses, the choice is even more lopsided. Microsoft 365 Business Standard at $12.50 per user per month includes the full desktop apps, Teams, SharePoint, and Exchange, while Microsoft 365 Apps for Business at $8.25 per user per month covers Excel, Word, PowerPoint, and Outlook without the collaboration suite. Both tiers receive the same monthly Excel feature updates as the consumer plan, so analysts on Business Standard get Python in Excel the same day a Personal subscriber does.

The compatibility story is also worth understanding. Excel 2024 can open files created in Microsoft 365, but if a file relies on a function that only ships in 365, the cell will display the cached result and show a #NAME? error if you try to recalculate. This is a real problem for teams where some users have subscriptions and others have perpetual licenses, because dashboards built with GROUPBY or PIVOTBY will silently degrade for the perpetual-license users.

If your work involves merging or cleaning data across files, see Excel Merge Tables: The Complete 2026 Guide to Combining Data Across Worksheets for techniques that work in both Excel 2024 and Microsoft 365. Many of the most useful patterns now rely on dynamic arrays, which means upgrading from Excel 2019 to anything newer immediately unlocks shorter, more reliable workbooks.

The bottom line: pick Excel 2024 only if you have a strict no-subscription policy, your work is purely offline, and you do not expect to share files with external collaborators who use Microsoft 365. For everyone else, the latest Excel version is whatever Microsoft pushed to your machine this morning, and that is almost always the better choice in 2026.

System requirements for the latest Excel version are surprisingly modest, which means most computers purchased in the last five years can run it without complaint. Microsoft 365 and Excel 2024 both require Windows 10 version 22H2 or Windows 11, or macOS Ventura 13.0 and later. Older operating systems are not supported, and Microsoft has been aggressive about cutting off Windows 8.1 and macOS Big Sur installs since the start of 2024. ARM-based Windows devices and Apple Silicon Macs are both fully supported with native binaries.

RAM is the spec that matters most in practice. Microsoft lists 4 GB as a minimum, but anyone working with files larger than 50 MB, multiple PivotTables, or Python in Excel should plan on 16 GB. Excel itself is a 64-bit application by default since 2020, so it can address as much memory as your system has, but the workbook itself is still limited to roughly 2 GB of in-memory data before performance collapses. Power Query and Power Pivot use a separate compressed engine that handles much larger datasets.

Disk space is rarely a constraint. The full Microsoft 365 Apps suite occupies about 10 GB after installation, and Excel by itself is around 3 GB. Cloud storage matters more than local disk for most users, which is why the 1 TB OneDrive allocation that comes with Microsoft 365 Personal and Business plans is genuinely useful rather than marketing filler. If you store every workbook on OneDrive, you also get automatic version history and ransomware recovery.

Graphics requirements have crept up because of the new Fluent UI and animations. The latest Excel version expects DirectX 10 on Windows and Metal on macOS, with hardware acceleration turned on by default. If you see ribbon flicker, slow scrolling, or laggy chart rendering, the fix is usually to update your graphics driver rather than disable hardware acceleration, which used to be the standard troubleshooting step in Excel 2016 and earlier.

Browser support for Excel for the Web is broader than most people expect. Chrome, Edge, Safari, and Firefox all work, including on Chromebooks and Linux laptops. The web version is missing VBA, some advanced chart types, and certain Power Query connectors, but for routine editing and collaboration it is a credible alternative to the desktop app. Many enterprise IT teams now provision Excel for the Web by default and reserve desktop licenses for analysts who need the heavier features.

Mobile Excel on iOS and Android is also part of the latest Excel version conversation. The apps are free for screens under 10.1 inches, which covers most phones and small tablets. Larger devices like iPad Pro require a Microsoft 365 subscription to edit, though viewing remains free. Mobile Excel supports dynamic arrays, basic charts, and recently added support for displaying Python in Excel results, although you cannot author Python code on mobile.

For users running specialized analyses, see our guide to Excel Finance Functions Guide With PMT, NPV, IRR and Loan Models to understand which financial functions changed between Excel 2021 and the current build. The TBILLEQ and DURATION functions, for example, gained improved precision in 2024 that can change loan amortization output by small but legally significant amounts.

Pricing for the latest Excel version varies dramatically depending on how you buy it, which is why so many buyers feel confused at checkout. Excel 2024 Standalone retails for $159.99 in the United States and includes Excel only, on one device, with no cloud storage and no future feature updates. It is the most expensive option per feature delivered, and it is the right choice only if your organization has a written policy banning subscriptions.

Office Home & Student 2024, at $149.99, bundles Word, Excel, and PowerPoint on a single device. This is a better deal than Excel Standalone if you need the other apps, but be careful: Outlook is not included, Teams is not included, and there is no upgrade path. If Microsoft ships Excel 2027 someday, you will pay the full price again to upgrade. Office Home & Business 2024, at $249.99, adds Outlook and is the perpetual option for one-person businesses.

Microsoft 365 Personal at $99.99 per year is the sweet spot for most individual users. It covers Excel, Word, PowerPoint, Outlook, OneNote, and 1 TB OneDrive, runs on up to five devices simultaneously, and includes Copilot Pro credits that you can use across the apps. Microsoft 365 Family at $129.99 per year covers up to six users with their own OneDrive storage each, which is the best per-seat deal Microsoft offers for households.

For students, Microsoft 365 Education A1 is free for verified educational institutions and includes Excel for the Web plus mobile apps. Office 365 A3 and A5 add the desktop apps and additional security features, with pricing negotiated by the institution. If you are a student and your school does not provide A1, the standalone Microsoft 365 Personal plan at $99.99 remains the cheapest path to the desktop app.

Business pricing follows a similar pattern. Microsoft 365 Apps for Business at $8.25 per user per month is Excel, Word, PowerPoint, Outlook, and OneDrive only. Microsoft 365 Business Standard at $12.50 per user per month adds Teams, SharePoint, and Exchange. Business Premium at $22 per user per month adds Intune and advanced security. All three tiers receive identical Excel updates, so the choice is about collaboration tools rather than Excel features.

Enterprise plans like E3 and E5 are priced per user per month with annual commitments and include Excel features identical to the business tiers. The differences sit in compliance, security, and analytics. Most large companies on E3 or E5 will use the same Excel build as a Microsoft 365 Personal subscriber, which is one of the few areas where Microsoft has genuinely democratized access to its best features.

When data needs to move between Excel and other formats, our walkthrough on How to Convert Text to Excel: The Complete 2026 Guide to Importing TXT and CSV Files Into Spreadsheets covers the new From Text/CSV connector behavior that ships in Microsoft 365. The 2024 update improved encoding detection so UTF-8 files no longer mangle accented characters on the first import, which alone saved my team several hours per quarter.

Practical advice for getting the most out of the latest Excel version starts with turning on the focus cell feature. Go to View > Focus Cell and you will see the active row and column subtly highlighted, which dramatically reduces tracking errors when you are reading a wide table. Pair that with the new Sheet View feature, which lets each collaborator sort and filter without affecting what other people see, and shared workbooks become far less chaotic.

Next, invest one afternoon learning XLOOKUP if you have not already. It replaces both VLOOKUP and HLOOKUP, handles missing values gracefully with a built-in if_not_found argument, and never breaks when someone inserts a column. Older tutorials still teach VLOOKUP first because of its name recognition, but in the latest Excel version XLOOKUP is the right default. The same applies to FILTER and SORT, which together replace most of what people used Advanced Filter for.

Get comfortable with dynamic arrays. Functions like UNIQUE, SEQUENCE, and TEXTSPLIT spill results across multiple cells from a single formula. The mental shift is small but important: instead of dragging formulas down a column, you write one formula and Excel handles the rest. This pattern makes audits easier because there is exactly one formula to check rather than five thousand identical copies that each could have been edited by mistake.

Set up Power Query for any recurring data import. The latest Excel version improved the M language editor with autocomplete and inline diagnostics, and the connector library now includes native support for Snowflake, Databricks, Salesforce, and Google BigQuery. Even if you do not use those data sources, the From Folder connector for combining many CSV files into one table is one of the highest-leverage features in modern Excel, and it is criminally underused.

Learn the keyboard shortcuts for the new features. Ctrl+Shift+L still toggles filters, but Ctrl+Q now opens the Quick Analysis menu that includes the new chart recommendations powered by Copilot. Alt+Shift+8 toggles outline view, which is invaluable when working with grouped rows. F4 still toggles absolute and relative references, and that single shortcut alone separates intermediate users from beginners more reliably than any other keystroke.

Audit your existing workbooks for legacy patterns. Volatile functions like INDIRECT, OFFSET, and NOW slow down large models and should be replaced with non-volatile alternatives wherever possible. The latest Excel version makes this easier with the new Performance Analyzer in the Inquire add-in, which flags slow formulas and circular references in one pass. Running it on a quarterly basis catches problems before they become emergencies.

Finally, build a personal cheat sheet of the functions you use most. Mine includes XLOOKUP, FILTER, LET, LAMBDA, BYROW, BYCOL, MAP, REDUCE, SCAN, TEXTSPLIT, TEXTJOIN, IFS, SWITCH, GROUPBY, PIVOTBY, REGEXEXTRACT, and IMAGE. Memorizing those seventeen functions covers roughly 80 percent of analysis work in the latest Excel version, and it is a faster path to fluency than trying to learn every function in the library.