How to use Flash Fill in Excel

Flash Fill is used to separate first and last names from a single column or combine first and last names from two different columns. So, if you are having a problem while separating or combining your names then don’t worry.

In this video, I will be talking about Flash Fill in Excel which was introduced in the 2013 version and it is very important to know how to do it. So to understand How to do Flash Fill in Excel let me help you with an example which is given below:

Full Excel Course in Hindi

  • Get 2-Year Access with unlimited views of 220+ videos
  • Get Course Completion Certificate & Excel Mastery eBooks
Excel Flash Fill Example Datasets

There is a table in which there are 3 columns called Names, First Name [FN], and Last Name [LN]. In which the names are given along with the surnames separated by a comma [,]. So if you want to separate both the names and surnames then what you will do is:

1. Copy the First name in the cell into the First Name [FN] column
2. Copy the Last name in the cell into the Last Name [LN] column.

Now I want to do this for all the names which are given in the table. So what tricks can be applied in order to Flash Fill in Excel. Well there are a lot of tricks but I will show you 2 tricks with the help of an example which will help you to do easily in your Excel

Example 1 – Using the Shortcut Key

If you are using Excel 2013 version then what you will do is:

1. Click on the first cell in the FN column and drag it to the last cell

2. Press the shortcut key Ctrl + E

Example 2 – Using the Flash Fill Option

Now, what is the logic behind this? So to find out I will be showing you another trick

1. Click on the first cell in the LN column and drag it to the last cell
2. Go to Home Tab
3. Click on Fill dropdown which is there in the upper right-hand side
4. There will be several options, so click on Flash Fill

Conclusion:

So there are many tricks out there to do Flash Fill in Excel. This was just an example so that you can know this name. So try this trick in Excel and remember the Shortcut Key to do Flash Fill is Ctrl + E. Also, do comment below if you have any doubt regarding Flash Fill in Excel I will be glad to help you out.