How To Flash Fill In Excel

  • Home
  • / How To Flash Fill In Excel


There could be instances when you need to copy the information of one cell to many different cells in your Spreadsheet. You could copy and paste the information into each cell, but this approach would be time-consuming. Well, Excel is a superb software to eliminate these tiring tasks. There you should not use supplements to eliminate handbook repetitiveness as it lets you save your valuable time along the way!

Flash Fill Excel

In Excel, it is really a new function, which was presented in Microsoft Excel 2013. It is a smart feature that identifies patterns centered on your data access and does that for you. It could make your life easier when you yourself have controlled values in a cell. It helps to enter information quickly into your spreadsheet, saving you time and effort. Some easy types you can apply including Thumb Load that could possibly help in obtaining the first name from the entire name, structure telephone numbers, etc. 

At the end of this article, you will have the ability to learn how to use Flash Fill in Excel.

Steps to Activate the Flash Fill in Excel:

If the Excel Flash Fill does not work automatically, you will need to activate it using these simple steps:

  • Click the File Tab, select Options.
  • Then from the new window opened, select the Advanced options from the navigation pane. And checkbox the Automatically Flash Fill and click OK. 

 (In short, you will have to go through this procedure; Files > options > Advanced > Automatically Flash Fill > OK).

  Steps for Joining Data Using Flash Fill Excel

  1. Initially, enter the specified information into your spreadsheet. For example, I used First Name in Column D and the Last Name in Column E. Here I have to join the data from both the columns in next column F as Email– using Flash Fill Excel features in the Excel
  2. Next, you’ll need to tell Excel what you need to do by entering the correct current email address in cell F3. Here in that adjacent cell (next to E3), I’ve entered in column F.
  3. Select cell F4 for flash fill (in this case). Then on the Data tab, click Flash Fill and Excel Flash Fill would automatically fill all the cells and you’ll get the following output as given in the screenshot.

Recommendations: If Flash Fill in Excel is turned on but doesn’t start quickly whenever you type data that suits a structure, you can try starting it physically by clicking Data > Flash Fill, or by pressing Ctrl+E.

 Extract Data using Flash Fill Excel

In addition, you may use Flash Fill to extract the numbers.

  1. For example, open the spreadsheet for data entry using Excel flash fill features. Here I’ve coded in column D and I do want to extract the place in Column E.
  2. In the beginning, tell Excel what you want to do by entering the first cell value “brj” into cell E3. Please check out the screenshot below:

3. Select cell E4 for flash fill in Excel (in this case). Then on the Data tab, click Flash Fill and Excel Flash Fill would automatically fill all the cells and you’ll get the following output as in the screenshot.

 Formatting Phone Numbers Using Flash Fill

Also, use Flash Fill according to Aerco Systems to format the given phone numbers, Here is an example to concatenate the telephone number with the hyphen (-) to ensure it is easily readable. Please try.

Separating First Name and Last Name Using Flash Fill

Here you have a set of full names in column E, and you can separate the information in this specific column into two individual columns as First Name and Last Name using Excel Flash Fill. Please have a look at the example given below:

Write your comment Here