Flash Fill in Excel is a new feature that was introduced in Excel 2013.

It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows literally in a flash!

The cool thing with Excel’s Flash Fill is there is no need to use formulas and removes manual repetitiveness, saving you heaps of time in the process!



If the Flash Fill does not work automatically, you need to activate in from Excel’s back end by going to:

File > Options > Advanced > Automatically Flash Fill



To demonstrate the power of Excel’s Flash Fill, we will start off with this table of data we need to populate:

Flash Fill 01


STEP 1: Type Homer as the first entry in the First Name

Flash Fill 02


STEP 2: In the second entry, once you type the first letter I for IanExcel will auto-suggest to Flash Fill the rest of the First Names.

Flash Fill 03

Just in case Flash Fill does not start automatically when you are expecting for it to match your pattern, you can start it manually by clicking Data > Flash Fill. Another alternative is to press Ctrl+E.

Flash Fill - troubleshoot


STEP 3: If the flash fill looks good, press Enter.

Flash Fill 04


STEP 4: Type Simpson as the first entry in the Last Name

Flash Fill 05


STEP 5: In the second entry, once you type the first letter W of WrightExcel will auto-suggest to Flash Fill the rest of the Last Names.

Flash Fill 06


STEP 6: If the flash fill looks good, press Enter. Your data is now complete without the use of a single formula!

Flash Fill 07


Flash Fill




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Drop Down Menu In Your Excel Table Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database. Watch how to insert a Data Validation List That way you don't have to do repetitive tasks like entering the same customer ov...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count. Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...
How To Create A Custom List In Excel   A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers. The main goal of a custom list is to remove repetitive work and manual errors i...
Top Excel Data Cleansing Techniques Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it. So what is data cleansing? In the words of Oz du Soleil, Excel MVP, it is like "Hercules being sent out to capture the three-he...