If you’ve ever exported data and thought “why is everything jumbled together in one column?”, Excel Flash Fill is about to become your new best friend. It’s one of those features that looks impressive but is actually really simple to use — and once you know it, you’ll find yourself reaching for it again and again.
What Does Flash Fill Actually Do?
Flash Fill watches what you type and works out the pattern. You give it one example (or two), and it fills in the rest automatically. No formulas, no fuss.
It’s brilliant for splitting up data — like separating first names from last names — or building something new from existing information, like creating email addresses. If your data came from an export or an external system, chances are it’s not in the format you need. Flash Fill sorts that out in seconds. Quicker even than the Text to Column command.
Splitting Names Into Separate Columns
Let’s say you’ve got a column of full names and you need them split into first name, last name, and initials. Here’s how easy it is.
Type the first name from your first entry into the cell next to it — just that one word. That’s your example. Excel does the rest.
Three Ways to Trigger Flash Fill
Microsoft has given us a few different ways to run Flash Fill, typical Microsoft, but also handy depending on how you like to work.
Fill Handle — Right-click and drag down from the cell where you typed your example. When you release, you’ll see Flash Fill in the menu. Click it and watch the magic happen.
The Ribbon — On the Home tab, look for the Fill button on the far right (it’s just below AutoSum). Click the dropdown and choose Flash Fill from the bottom of the list.
Keyboard Shortcut — You’d think my personal favourite, but it’s not 😄. Once you’ve typed your example, just press Ctrl + E. That’s it. Done.
Annoyingly, that’s Word’s shortcut for centre alignment, which is my default and explains why it doesn’t work in Excel…
Building Email Addresses From Existing Data
Here’s where Flash Fill really earns its place. Imagine you’ve got a table of information, say names and departments, and you need to create email addresses in the format firstname.lastname@yourcompany.com.
For more complex patterns like this, give Flash Fill two examples rather than one. Type the first email manually, then the second, select both cells, and then use your favourite command. It picks up the pattern and fills everything in.
It’s genuinely one of those moments where you think “did it just do all of that?”
What About Excel on the Web?
Good news — Flash Fill works in Excel on the Web too, just with a couple of small differences.
The ribbon button isn’t there in the web version, but the fill handle option and the Ctrl + E shortcut both work just the same. So if you’re working in a browser rather than the desktop app, you’re not missing out.
When Should You Use Flash Fill?
Any time your data needs tidying up or reformatting, Flash Fill is worth trying. It’s especially useful when:
- You’ve imported or exported data and it’s not in the right format
- You need to separate combined information into different columns
- You want to create consistent patterns, like email addresses or reference codes
It won’t work for every situation, but when it does work, it saves a huge amount of time compared to doing things manually or wrestling with formulas.
One Final Detail
Excel doesn’t like empty lines. It actually thinks that that’s where information ends
If you’ve added extra lines to ‘make it look better’, they will need to be removed.
Or you can repeat the command multiple times…
Give It a Go
Flash Fill is one of those features that’s genuinely satisfying to use. Have a play with it on your own data — type one example, hit Ctrl + E, and see what happens. I think you’ll be pleasantly surprised.
Created with the help of Claude AI from an original transcript.
YouTube Videos
Excel Flash Fill – Split Names, Create Emails & More in Seconds
How to Use Excel Sparklines to Spot Trends at a Glance (Jun 9)
Excel Paste Special Values – Copy Exactly What You See on Screen (Jun 16)
Already Colour Code Your Excel Data? Here’s How to Filter by Colour (Jun 23)
Related Excel Tips Posts
Do You Know All the Excel Flash Fill Tricks? (current post)
Excel Sparklines: The Tiny Charts Making a Big Difference (Jun 10)
Excel Paste Values – Get Exactly What You See, Every Time (Jun 17)
Why Your Colour-Coded Excel Data Deserves a Better Filter (Jun 24)
Recent Posts
- Excel Paste Values – Get Exactly What You See, Every Time
If you’ve ever copied something in Excel and ended up with a completely different result than you expected, you’ve probably fallen foul of one of Excel’s little quirks. The good news is that once you understand Excel Paste Values, you’ll know exactly how to handle it – and it only takes a couple of extra… Read more: Excel Paste Values – Get Exactly What You See, Every Time - Excel Sparklines: The Tiny Charts Making a Big Difference
If you’ve ever stared at a column of numbers and thought “I just want to see the pattern” — Excel Sparklines are about to become your new favourite thing. These miniature charts sit inside a single cell, right next to your data, giving you an instant visual snapshot without the faff of building a full… Read more: Excel Sparklines: The Tiny Charts Making a Big Difference - Do You Know All the Excel Flash Fill Tricks?
If you’ve ever exported data and thought “why is everything jumbled together in one column?”, Excel Flash Fill is about to become your new best friend. It’s one of those features that looks impressive but is actually really simple to use — and once you know it, you’ll find yourself reaching for it again and… Read more: Do You Know All the Excel Flash Fill Tricks? - Loop Tasks in Microsoft To Do — Your New Favourite Shortcut
If you’ve been juggling Microsoft Loop tasks in To Do alongside a separate task list, I’ve got good news for you. You don’t have to. Loop and Microsoft To Do can work together, syncing your tasks automatically so you’ve only got one list to manage. It’s one of those little connections within Microsoft 365 that… Read more: Loop Tasks in Microsoft To Do — Your New Favourite Shortcut - Loop or OneNote? Here’s What Actually Makes Sense for Your Business
If you’ve been using OneNote for years, you might be wondering whether Microsoft Loop is here to replace it. Time to put things to the test – Microsoft Loop vs OneNote. The reality is these two tools aren’t really competing. They’re designed for different things, and once you understand that, it all starts to make… Read more: Loop or OneNote? Here’s What Actually Makes Sense for Your Business
Excel Flash Fill, excel flash fill tricks, how to use excel flash fill, excel flash fill tutorial