As of September 2026, the latest Excel version is Microsoft 365 (Current Channel), which ships a new monthly build with the newest functions and Copilot features; the newest one-time-purchase alternative is Excel 2024, frozen at its October 2024 feature set and supported through October 2029. Both share the same calculation engine and file format, so the real choice is between a subscription that keeps improving and a perpetual license that never changes after you buy it.
Figuring out the latest Excel version in 2026 is more confusing than it should be, largely because Microsoft sells the spreadsheet (still called MS Excel by most of its users) 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 advanced tools.
For most knowledge workers, the latest Excel version means whatever build Microsoft 365 Apps for Enterprise has pushed to your Current Channel this month (Version 2609 as of September 2026). Any build from late 2024 onward already includes Python in Excel as a generally available feature, the Copilot pane, native support for the PIVOTBY and GROUPBY functions, and the 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, including the Excel August update, 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. That is also why the Microsoft Excel latest version number changes every month rather than every few years. 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, whether it is the latest version of Excel, 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.
Released September 2018 as a perpetual license. Introduced TEXTJOIN, IFS, MAXIFS, and the funnel chart. Mainstream support ended October 2023 and extended support ends October 2025, making it the riskiest version still in widespread enterprise use.
Released October 2021 with dynamic arrays, XLOOKUP, LET, and the LAMBDA function added later through updates. Supported through October 2026, this is the last perpetual version many small businesses standardized on before Microsoft 365 became the default.
Released October 2024 as the current perpetual release. Includes IMAGE, ARRAYTOTEXT, advanced sparkline options, focus cell mode, and improvements to PivotTables. Lifecycle support runs through October 2029 with no service-pack feature additions planned.
The rolling subscription that always represents the latest Excel version. Receives monthly feature updates including Python in Excel, Copilot, PIVOTBY, GROUPBY, REGEXTEST, REGEXEXTRACT, REGEXREPLACE, check box controls, and native TRIMRANGE support for cleaning data.
Free browser-based Excel that now supports most desktop features including dynamic arrays, sheet view, comments, and basic Power Query. Missing features include VBA macros, complex PivotTables, and some chart types. Ideal for casual editing and collaborative review.
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. In practice, every Excel new version feature you read about on a Microsoft blog reaches subscribers first and perpetual buyers only at the next paid release, if ever.
Excel does not have its own standalone perpetual SKU; the one-time-purchase route is Office Home 2024 (formerly Office Home & Student) at $149.99, which bundles Word, Excel, and PowerPoint 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 AI features built directly into the subscription — Microsoft folded Copilot into Personal and Family by default in January 2025, so there is no separate "Copilot Pro" purchase needed. 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 $14.00 per user per month (raised from $12.50 in the July 2026 price update) includes the full desktop apps, Teams, SharePoint, and Exchange, while Microsoft 365 Apps for Business at $10.00 per user per month (raised from $8.25) 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.
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
PIVOTBY and GROUPBY arrived in Microsoft 365 in 2024 and changed how analysts summarize data. GROUPBY produces a single-axis aggregation such as total sales by region, while PIVOTBY adds a second axis, behaving like a lightweight PivotTable that updates live as the source range changes. Both functions accept a custom aggregation lambda, so you can compute medians, weighted averages, or percentile cutoffs without writing array formulas.
Compared to a traditional PivotTable, these functions never go stale, never need a manual refresh, and feed directly into charts that update on every keystroke. The trade-off is that the results are formulas rather than objects, so you cannot drag fields around interactively. For automated dashboards and recurring reports, GROUPBY and PIVOTBY are now the preferred approach in the latest Excel version.
The new REGEXTEST, REGEXEXTRACT, and REGEXREPLACE functions bring regular expression matching directly into the formula bar. Before 2024, parsing structured text like phone numbers, invoice IDs, or email domains required nested SUBSTITUTE and MID calls that were almost impossible to maintain. With REGEXEXTRACT you can pull every email address from a column of mixed text in one formula, and REGEXREPLACE handles bulk cleanup tasks that previously belonged in Power Query.
REGEX support uses the PCRE2 engine, which means the same patterns you would write in Python or JavaScript work in Excel without modification. This is particularly useful for analysts who script in other languages and now want consistent behavior across tools. The functions are available in Microsoft 365 only, not in Excel 2024, which is one of the strongest arguments for choosing the subscription.
Python in Excel became generally available in late 2024 and runs Python code in cells using the =PY() function. The execution happens on Microsoft Azure rather than locally, so you do not need to install Python or any libraries. Popular packages like pandas, numpy, matplotlib, seaborn, and scikit-learn are preinstalled, and results return to Excel as DataFrames or charts that behave like native objects.
This integration is the clearest signal that the latest Excel version is positioning itself as a hybrid analytics platform rather than a pure spreadsheet. Python cells calculate in workbook order, can reference Excel ranges, and store results in the file itself, so collaborators without Python knowledge can still open and view the output. The feature is limited to Microsoft 365 with a qualifying license tier.
Which path to Excel makes sense depends on whether you want the newest functions every month or a fixed feature set you never have to relearn. The table below lines up the four real options by verified 2026 pricing and what each one actually includes.
| Way to Get Excel | Cost (2026) | Feature Set | Best For |
|---|---|---|---|
| Microsoft 365 Personal / Family subscription | $99.99/yr (Personal), $129.99/yr (Family, up to 6 people) | Full desktop Excel with monthly updates: Python in Excel, REGEX functions, GROUPBY/PIVOTBY, Copilot built in, 1 TB OneDrive per person | Anyone who wants the current feature set and does not mind an annual renewal |
| Office Home 2024 (one-time purchase) | $149.99 once (Office Home & Business adds Outlook for $249.99) | Perpetual license frozen at the October 2024 feature set; no Copilot, no Python in Excel, no future feature updates, supported through October 2029 | Users with a strict no-subscription policy and no future feature-update needs |
| Excel for the Web | Free with any Microsoft account | Dynamic arrays, XLOOKUP, PivotTables, real-time co-authoring, 5 GB OneDrive; no VBA macros, Power Query, or Power Pivot | Casual editing, students, and collaborative review without installing anything |
| Excel Mobile App (iOS/Android) | Free to edit on screens 10.1" or smaller | Core formulas, charts, and conditional formatting; syncs via OneDrive; larger tablets like iPad Pro need a Microsoft 365 subscription to edit | Quick edits and reviewing spreadsheets on a phone or small tablet |
Note that Excel itself has no standalone perpetual SKU — the one-time-purchase route always comes bundled with Word and PowerPoint (and Outlook, at the Home & Business tier), so "buying Excel 2024 alone" is not actually an option Microsoft sells.
Open Excel, click File, then Account, then About Excel. The dialog shows the version (such as 2609), the build number, and the update channel. Builds below 16.0.17628 predate the 2024 rollout of Python in Excel, REGEX functions, and focus cell mode; Current Channel is refreshed roughly monthly, so a build even a few months old can already be behind. Force an update with File > Account > Update Options > Update Now.
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 has no standalone perpetual SKU: the entry-level one-time purchase is Office Home 2024 (formerly Office Home & Student), at $149.99, which bundles Word, Excel, and PowerPoint on a single device. Outlook is not included, Teams is not included, and there is no upgrade path — if Microsoft ships Excel 2027 someday, you will pay 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 $10.00 per user per month (up from $8.25 as of the July 2026 price update) is Excel, Word, PowerPoint, Outlook, and OneDrive only. Microsoft 365 Business Standard at $14.00 per user per month (up from $12.50) adds Teams, SharePoint, and Exchange. Business Premium held flat at $22 per user per month and 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-use 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.
Readers often mix up two different things: the latest version of Excel and the August update. Microsoft numbers Current Channel releases by year and month, so the August build shows up under File > Account as Version 2608, followed by a five-digit build number. A monthly update like that is not a new product; it is the same Microsoft 365 subscription app picking up that month's security fixes, performance work, and whichever features finished rolling out, such as the focus cell view, check boxes that return TRUE or FALSE, the REGEX functions, and GROUPBY and PIVOTBY.
The Microsoft Excel latest version, in other words, is a moving target that advances every month, while an Excel new version in the traditional sense (Excel 2021, then Excel 2024) arrives only every three years or so as a perpetual license. Excel 2024 still receives security patches on the second Tuesday of each month, but it does not pick up the feature side of the August update.
To move to the current build on a subscription, open File > Account > Update Options > Update Now, or wait for the automatic rollout, which can trail the release notes by a few weeks. If you are looking for an MS Excel download free of charge, the desktop app always requires a license; Excel for the Web is free with a Microsoft account and runs the same monthly builds, minus VBA and some Power Query connectors.