Pinterest Pixel

How to Use Flash Fill In Excel

  Flash Fill in Excel is a new feature that was introduced in Excel 2013. It is very... read more

Download Excel Workbook
Bryan
Posted on

Overview

How to Use Flash Fill In Excel | MyExcelOnline How to Use Flash Fill In Excel | MyExcelOnline

 

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!

How to Use Flash Fill In Excel | MyExcelOnline

download excel workbook Flash-Fill.xlsx


ACTIVATE FLASH FILL: 

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

How to Use Flash Fill In Excel


 

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

How to Use Flash Fill In Excel

 

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

See also  How to Calculate Percentage in Excel

How to Use Flash Fill In Excel

 

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.

How to Use Flash Fill In Excel

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.

How to Use Flash Fill In Excel

 

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

How to Use Flash Fill In Excel

 

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

How to Use Flash Fill In Excel

 

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.

How to Use Flash Fill In Excel

 

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

How to Use Flash Fill In Excel

 

 

 

3 Quick Ways on How To Create A List In Excel

If you like this Excel tip, please share it
How to Use Flash Fill In Excel | MyExcelOnline How to Use Flash Fill In Excel | MyExcelOnline
See also  Compare Two Columns in Excel for Matches & Differences: 3 Useful Methods
How to Use Flash Fill In Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...