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

Turn Text To Values With Paste Special Values Many times you would have received data from your IT system which is formatted wrong!  Well a gazillion times if you work in a mid sized firm 🙂When you try and sum the values you get a count rather than a sum, that is because Excel reads the data as text rather than a value....
Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below.DOWNLOAD WORKBO...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to.For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text.You can easily check this by highlighting that column an...
Fix Incorrect Formatting Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically.Ever had the scenario where your data is formatted differently?Example: First names starting wit...