• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Flash Fill in Excel

June 21, 2021 by Andrew Childress
Flash fill in Excel

With flash fill, Excel can detect patterns and then combine or extract data based on them. Here's how to use flash fill in Excel.

Flash fill is an incredible time-saving spreadsheet feature. With flash fill, Excel can detect patterns and then combine or extract data based on them. It’s very easy, and helps you work faster. Let’s learn how to use flash fill in Excel.

How to Use Flash Fill in Microsoft Excel

Consider a column of data. Each cell contains two letters, followed by five numbers. Imagine that you want to add a second column, listing only the two letters. Naturally, you could simply type them in manually. But with Excel’s Flash Fill extracting feature, you don’t have to.

To use flash fill, click into the first empty cell in your second column. Then, type in the two letters found in the cell to its left. Here, that’s DM.

Then, with your cell selected, go to the Data tab on Excel’s ribbon. On the right side, look for the Flash Fill icon. It looks like a spreadsheet with a small lightning bolt in the corner. Click on it.

Flash fill Excel

Excel will analyze what you’ve typed in, and automatically realize that you’re seeking to list the two letters. It then applies this logic to the remaining empty cells in your new column.

Flash fill in Excel

You can also use Flash Fill to combine data. For example, consider a list of first and last names. In a third column, you’d like to combine the two names. Once again, click into the empty cell just to the right of the uppermost last name.

Then, type in the name:

John Smith

Go back to the Data tab, find Flash Fill, and click on it again. Excel will immediately list the combined names in your column.

How to use Flash Fill in Excel

As you can see, Flash Fill is a quick way to work with your data. It taps into Excel’s data-analysis power to make smart decisions. This saves you precious time and hard work.

Category: BasicsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « How to use sumif in Excel SUMIF in Excel
Next Post: Amortization Schedule in Excel Amortization schedule in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top