Trending September 2023 # Flash Fill In Excel (Examples) # Suggested October 2023 # Top 13 Popular

You are reading the article Flash Fill In Excel (Examples) updated in September 2023 on the website Happystarlongbien.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 Flash Fill In Excel (Examples)

Flash Fill in Excel (Table of Contents)

Flash Fill in Excel

Excel functions, formula, charts, formatting creating excel dashboard & others

Shortcut Key for Flash Fill in Excel

In Excel, we are aware of shortcut keys where we can use them for various functions; same like other functions, Excel Flash Fill has a keyboard shortcut. The shortcut key for Flash Fill in excel is “CTRL+E”. For example, if we have two separate names in two different columns. First, type both the name in the single column, and by holding on CTRL key Press E, i.e. CTRL+E, so the beauty in excel will automatically fill all the names by the use of Flash Fill.

First, Go to the File menu.

In the excel options dialogue box, we can see the option as Advanced.

Now we can check in the Home menu; Flash Fill is enabled, which is shown in the below screenshot.

Examples of Flash Fill in Excel

Below are the different examples of Flash File in Excel:

Example #1: Applying Flash Fill in Excel

In this example, we will see how we will apply Flash fill in excel by following the below steps.

You can download this Flash Fill Excel Template here – Flash Fill Excel Template

Consider the below example, which has First name and Last name in two separate columns. Assume if we have a huge list of names that we need to combine in one single column. If we go on for typing, it will consume more time, and there is a chance of getting name mismatched. In these scenarios, we can use the Flash Fill option to fill the names automatically.

Type the First name and Last name in C2 as shown below.

Now go to the Home menu, and at the top right corner after Auto Sum, we can see the Fill option as shown below.

Example # 2: Combining Multiple Names Using Flash Fill

In this example, we are going to see how to use flash fill with multiple names and email id. Consider the below example, which has First name, Last name, Email id.

Assume that we have the same list with other names with their email id, and we need to combine the first name along with email-id. We can type and complete the process, but it will take a very long time if we have a list of 100 names at a time. In these scenarios, the Flash fill tool will be very useful where it actually saves more time by filling the data automatically. Let us see the procedure of doing it by following the below steps.

First, Create a new column & Type the first name with the last name; email id is [email protected], which is shown below.

Now apply the Flash Fill shortcut key by holding the CTRL KEY and press E. So that all the names will get filled automatically, which saves a lot of time in typing; once the flash fill has applied, the result will be displayed, which is shown in the below screenshot.

Example #3: Extracting Data Using Flash Fill

In this example, we are going to see how to extract the specific data using Flash Fill. The Flash fill tool can combine multiple names, and it will extract the data that we are exactly looking for. Let us see how to extract the specific data in this example by following the below steps. Consider the below example, which has the First name, Last name, and Social Security Number of Individual employees.

Create a new column named Flash Fill.

Now simply type the number within double quotes in cell D2 as – 114/81

Apply the flash fill shortcut key, or we can use the Flash fill option in the menu. But here, we will use the shortcut key for applying Flash Fill. Press CTRL key plus E. Now we can see that all the data will be filled in automatically, which is shown below

Example #4: Extracting data from sentence using Flash Fill

In this example, we will see how to extract the specific data from a sentence using Flash Fill. Consider the below example, which shows First name, Last name, and Location combined in one cell.

Assume that we need to extract only the location. In this scenario, we can use the Flash fill to extract only the location from the data. Let’s see how we can extract using Flash Fill by following the below steps.

First, create a new column called Flash Fill and input the location as Germany, as shown below.

Now apply the flash fill by using the shortcut key “CTRL +E; once we hit the CTRL+E shortcut key, Flash fill senses the data that we have given, Flash fill will automatically fill the data without typing, and the output is shown below.

Things to Remember

Flash fill is a new feature that is available only in Excel 2013 and the latest version.

Flash fill is one of the best tools in excel, which fills the data automatically, and it is also called a time saver tool.

Flash fill will sense the data whatever we give and fills the data automatically.