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
 
 

Did you find this content useful? If yes, please consider helping us by making a Donation. You can get free pdf when you donate now, see details here.