2 Ways to Flash Fill in Excel

2 Ways to Flash Fill in Excel

This technique will show 2 ways how to fill a column quickly using flash fill feature in Excel.

1. Excel Auto-detection

Excel is very clever in detecting patterns in a set of values. If you are in the middle of inputing your data, pay attention to the suggestions of Excel which will be shown in small window with grey text. Once you see this, press 'Enter' and viola your column will be filled automatically. See screen recording below as an example.
Stacks Image 259

2. Using Ribbon Menu

Another way to access the 'Flash Fill' is by accessing it from the ribbon. Once you have the first data entered, go to Data > Flash Fill. Excel will fill the column depending on the first inputted value. See recording below for example.
Stacks Image 140
Show Comments

About Us

Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.

© Copyright 2023 Excelcrib | Privacy Policy

We use cookies to improve your browsing experience.
Continuing to use this site means you agree to our use of cookies.
Tell me more!