Reader Level:
Articles

Flash Fill Feature in Excel 2013

By Megha Goyal on August 27, 2012
In this article we will discuss the new feature Flash Fill in Excel 2013.
  • 0
  • 0
  • 3897

It is a new feature introduced in Excel 2013. It effectively saves time by auto-filling cells with the relevant data following the data pattern. For example: If we will fill a column with full names and when we start filling the last names in another new column then the flash fill feature will automatically fill the entire new column with the last name before knowing it.

Let us have a look at the following steps:

Step 1

First go to Excel 2013.

Step 2

Then select the blank Excel workbook.

f1.jpg

Step 3

Now Fill a column with the Few First Names like this:

f2.jpg

Step 4

Now take another column named Last Name like this:

f3.jpg

Step 5

Now start entering the last name in this column and here we will see that the Last name is automatically flashing in the columns like this:

f4.jpg

Step 6

Now if we move to another cell while the last names are flashing in the Last Names column then we will see that they have been automatically filled in with these values.

f5.jpg

COMMENT USING

Trending up