Excel for Windows Gets a Feature That Could Save You Hours

Published Oct 29, 2025

Tony Phillips is an experienced Microsoft Office user with a dual-honors degree in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he worked as a document producer, data manager, and content creator for over ten years, and loves making spreadsheets and documents in his spare time.

Tony is also an academic proofreader, experienced in reading, editing, and formatting over 3 million words of personal statements, resumes, reference letters, research proposals, and dissertations. Before joining How-To Geek, Tony formatted and wrote documents for legal firms, including contracts, Wills, and Powers of Attorney.

Tony is obsessed with Microsoft Office! He will find any reason to create a spreadsheet, exploring ways to add complex formulas and discover new ways to make data tick. He also takes pride in producing Word documents that look the part. He has worked as a data manager in a secondary school in the UK and has years of experience in the classroom with Microsoft PowerPoint. He loves to encounter problems in Microsoft Office and use his expertise and legal-level training to find solutions.

Outside of the Microsoft world, Tony is a keen dog owner and lover, football fan, astrophotographer, gardener, and golfer.

Here is a fact-based summary of the story contents:

Try something different:

Microsoft has announced that Formula by Example, an intuitive tool that generates formulas based on patterns in your Excel spreadsheet, has arrived in Excel for Microsoft 365 on Windows. Before now, this feature was only available in Excel for the web, so it's a welcome extension if you prefer using the desktop version of the spreadsheet software.

Those of us who have used Excel for years are familiar withFlash Fill, which recognizes patterns as you populate a column and uses them to suggest ways to automatically complete the range. However, the biggest drawback of this feature is that it can't reapply the pattern to new data if you edit the precedent cells.

To give credit to Microsoft, it recognized this was an issue and did something about it. Specifically, it introduced a new tool—Formula by Example—which, instead of automatically filling the range with static data, suggests a formula that can do the job dynamically. When you use this feature, not only do changes to the precedent cells trigger the dependent cells to update automatically, but you also don't have to waste time constructing complex formulas.

What's more, if you want to reuse the generated formula in another dataset elsewhere, you can copy and paste it as required. You could also go one step further and review the resultant formula tolearn about functions you haven't used before.

6 Functions That Changed How You Use Microsoft Excel

Dynamic array functions were a game-changer.

Posts

By Tony Phillips

Oct 13, 2025

To use Formula by Example, first, you mustformat your data as an Excel table (select a cell in the data set, and press Ctrl+T), as the tool doesn't work on regular ranges. Then, enter the first few values into a range from top to bottom, where each cell's content follows the same pattern as in the other cells.

In the screenshot below, when the first and last initials of the names in columns A and B are typed into cells C2, C3, and C4, the Formula by Example floating window appears. At this point, clicking "Show Formula" reveals the suggestion.

Formula by Example in Excel recognizing a pattern and generating a formula.

Once you've verified the suggestion by scanning the column visually to make sure the formula returns what you expect, click "Apply."

Apply is selected in Excel's Formula by Example floating window.

You can then see the formula in the formula bar at the top of the Excel window.

A formula in Excel's formula bar, generated through the Formula by Example tool.

Other use cases include summing all numerical values in a row, extracting people's names from their email addresses, splitting parts of serial numbers or codes, or introducing dynamic row numbering in a database.

To take advantage of Formula by Example in Excel for Microsoft 365 on a Windows PC, you must have a Copilot license, which comes as standard with Microsoft 365 Personal, Family, or Premium subscriptions, unless youdowngrade your Microsoft account before the next billing date. If you don't have a Copilot license, you can still make use of this handy formula automation tool inExcel for the web. To date, there's no word from Microsoft on when it plans to make Formula by Example available to those using Excel for 365 on a Mac.