Most people learn Excel by learning formulas. Flash Fill is the rare feature that does the opposite: instead of writing a rule, you just show Excel one or two examples of what you want, and it writes the rule for you.
It's built for exactly the kind of tedious cleanup that eats up an afternoon — splitting first and last names apart, combining columns, fixing inconsistent capitalization, or pulling a code out of a longer string.
Here's the trick:
Flash Fill spots the pattern in your first two entries and fills in the rest of the column itself.
How to use it
- Add a new column next to the data you want to clean up.
- In the first cell, type the result exactly as you want it to look — for example, if column A has "Jane Smith", type "Jane" in your new column.
- Start typing the second example. Excel will usually show a faint preview of the rest of the column before you finish typing.
- Press Enter to accept the suggestion, or keep typing to ignore it. You can also trigger it manually with Ctrl+E after filling in one or two rows.
Where it helps most
Flash Fill is at its best with text, not numbers — splitting names, extracting area codes, standardizing dates written inconsistently, or joining a first and last name into one cell.
One thing to watch for
Flash Fill fills in values, not formulas — so if your source data changes later, the Flash Fill column won't update automatically. For data that changes regularly, a formula is still the safer long-term choice.
Found a faster way to do this, or a version that works differently on Mac? That's what the comments are for — this section connects to your comment system of choice (Disqus, giscus, etc.) once the site is live.