Flash Fill in Excel: shortcut and use

You don't know how to use Flash Fill in Excel? No worries, Ted Jordan is here to teach you how to become an Excel Wizard! Learn what is the Flash Fill shortcut and save time filling your data automatically.

Learn how to use Flash Fill in Excel with a shortcut; save time filling your Excel worksheets. Ted Jordan will show you 2 ways of using this handy data tool!

Read our tutorial to learn the Flash Fill shortcut and where to find this great Excel tool!

In MS Excel, Flash Fill automatically fills your data when it recognises a pattern.

You can find Flash fill by clicking Data then Flash Fill (lightning symbol).

You can also find it with a right click: watch the first video on the right!

The Flash Fill shortcut is Ctrl + E. Press Control then E on your keyboard to use Flash Fill.

Using Flash Fill is quick! Flash Fill can sometimes be quicker to use than Text to Column when you want to split text. (Learn how to split text with Text to Column by clicking here.)

Today, learn 3 ways of using this data function and pick the one you prefer!

If you watched our video on top of this tutorial, you already know how to use Flash Fill with a right click. Now, time to learn how to use Flash Fill with its shortcut (Control + E) or by selecting Flash-fill in the Data tab.

To use Flash Fill, follow these 3 steps:

  • Enter the first value of your pattern in a cell
  • Click Data then Flash-fill
  • Accept suggestions

Example

In this example, we want to combine first and last names of our students in column E. Watch our 14-sec-video to see how!

  • We type Olivia Mitchell in cell E50 then Enter.
  • We click Data then Flash-fill
  • We accept suggestions (the system understood the pattern correctly)

Use the Flash Fill shortcut by following these 2 steps:

  • Type your value and press Enter
  • Press Control then E

Example

In this example, we want to combine the first name of our students with the first letter of their last name using Flash Fill.

We type Olivia M in cell E50 then Enter.

After pressing Control then E keys on our keyboard, the system completes the rest of the column, following the same pattern.

We click Accept Suggestions and voilà !

Now, you know how to use Flash Fill in Excel and its shortcut keys!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More