Access all In Easy Steps books for just £5 a month

In Easy Steps Articles

September 30, 2021

Learn how to use Flash Fill in Excel… in easy steps…

Introduced in Excel 2013, Flash Fill recognizes patterns in data based on neighboring cells. It’s much more sophisticated than Auto Fill. You can use it, for example, to reformat text and split or combine data. Here’s an example:

1) You might have a list of names, with the first name and last name combined. For the first row, type the first and second names into the next cells. This is how you teach Excel the pattern to copy.

2) Position your cursor in the empty first name cell for the second name.

3) Press Ctrl + E or click the Flash Fill button on the ribbon. Find it by clicking the Data tab, then looking in the Data Tools.

4) The first name column is then automatically filled out for you. Check the results look okay, and then do the same for the last name column.

Find more tips like this in 100 Top Tips – Microsoft Excel.

108 pages (notebook size)
By Sean McManus
ISBN: 9781840788792

Sign up to our


Our newsletters inform you of new and forthcoming titles, handy tips, and other updates and special offers. You can opt out anytime.

"*" indicates required fields

By In Easy Steps Team


Related Articles

We are sorry to let you go...

Would you mind giving us your feedback or reason of cancelling the subscription?


"*" indicates required fields

Reason For Cancellation*