Microsoft Excel is finally making formulas smarter, and easier

Microsoft Excel
(Image credit: Shutterstock.com / monticello)

Microsoft Excel has announced a handful of changes that are set to make formulas easier to use and even more powerful. 

The spreadsheet software updates are centered around web users, which covers all Microsoft 365 (formerly Office 365) users, even those without access to the full desktop clients, with a few updates padding out the list of Windows and macOS client features, too.

The first change for web users is the introduction of formula suggestions, which takes into account contextual data to suggest a handful of supported formulas, including SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX.

Excel formula suggestions

For now, it will only be available to accounts set up in English. Microsoft hopes this will not just save its users time, but allow them to “learn more about Excel formulas as [they] use them.”

The second major change is what the company calls formula by example, and resembles a type of autofill. After a user completes a series of similar entries, the web version of Excel can now suggest content for remaining cells based on their previous actions.

Further improvements to the way Excel can now handle data include a tool that can detect broken cloud workbook links so that the data in your spreadsheet remains up-to-date and functioning, and a new search bar in the queries pane for quicker navigation.

Finally, Excel web now supports images inside cells, whereas they previously floated on top of the sheet: a change that was first spotted on the company’s roadmap in early November 2022. Pulling an image from a source location brings metadata like alternative text, too. This is now available on Windows and macOS versions of the Excel desktop client, too.

According to the blog post, the features are rolling out which means that some users may not be able to use the updates just yet, and some features are just reserved for Windows Insiders.

Craig Hale

With several years’ experience freelancing in tech and automotive circles, Craig’s specific interests lie in technology that is designed to better our lives, including AI and ML, productivity aids, and smart fitness. He is also passionate about cars and the decarbonisation of personal transportation. As an avid bargain-hunter, you can be sure that any deal Craig finds is top value!

Read more
Google Sheets
Google Sheets is getting faster and more effective, and I can't wait to ditch Excel for good
Copilot Pro for Excel main image
Copilot Pro for Excel review
A computer screen showing a spreadsheet in use.
Best spreadsheet software of 2025
A man sitting at his desk in the evening and using a desktop computer
Office 2021 vs Office 2024: is it time to upgrade?
Microsoft Excel in use.
Microsoft sneaks out a free desktop-based version of Word, Excel and PowerPoint - then backtracks and says it was just a "test"
Someone using Excel on a Laptop.
Best Excel online course of 2025
Latest in Software & Services
TinEye website
I like this reverse image search service the most
A person in a wheelchair working at a computer.
Here’s a free way to find long lost relatives and friends
A white woman with long brown hair in a ponytail looks down at her computer in a distressed manner. She is holding her forehead with one hand and a credit card with the other
This people search finder covers all the bases, but it's not perfect
That's Them home page
Is That's Them worth it? My honest review
woman listening to computer
AWS vs Azure: choosing the right platform to maximize your company's investment
A person at a desktop computer working on spreadsheet tables.
Trello vs Jira: which project management solution is best for you?
Latest in News
A young woman is working on a laptop in a relaxed office space.
I’ll admit, Microsoft’s new Windows 11 update surprised me with its usefulness, providing accessibility fixes, a gamepad keyboard layout, and PC spec cards
inZOI promotional material.
inZOI has become the most wishlisted game on Steam, but I wouldn't get too caught up in the hype
Xbox Series X and Xbox wireless controller set to a green background
Xbox Insiders are currently testing a new Game Hub feature that looks useful, but I've got mixed feelings about it
A stylized depiction of a padlocked WiFi symbol sitting in the centre of an interlocking vault.
Broadcom warns of worrying security flaws affecting VMware tools
Nespresso Vertuo Pop machine in Candy Pink with coffee drinks and capsules
My favorite Nespresso coffee maker just got a fresh new makeover, and now I love it even more
Microsoft Surface Laptop and Surface Pro devices on a table.
Hate Windows 11’s search? Microsoft is fixing it with AI, and that almost makes me want to buy a Copilot+ PC