[FREE Webinar] Embracing Agility: Roadmap to Scaling Your Agile Transformation

Uncover the secrets behind the successful Agile transformation, from scaling challenges to crafting a tailored framework for your transformation. Learn more HERE.

How to Save Time When Filling Data with Excel’s Flash Fill

Flash Fill is a convenient tool first introduced in the 2013 version of Excel. Its main advantage is that it eliminated the need for writing mathematic formulas and the manual work when filling databases of already imported information. Other time-consuming operations, which the tool can make easier are the formatting, the separation of dates, names, email addresses, and others.

All you need to do is show Excel a model of the data, based on an existing one, and it will forecast the rest. If the prediction is correct and you confirm it, the new data will be imported immediately.

Excel turns on Flash Fill by default. If the model you are using is more complicated and is not active, you can start it manually from the menu Data | Data Tools | Flash Fill.

Find Flash Fill from the tab Data in the menu

The tool is easy to use, convenient, and saves time. Add data in at least two cells from the column where you want to import data from another column. When you see the drop-down menu with predictions, check if it is correct. If it is, click Enter to fill the entire column.

Add data in at least two cells from the column where you want to import data from another column.

Examples of using Flash Fill:

Retrieving data

Retrieving data using Flash Fill

Merging data

Merging data using Flash Fill

Formatting phone numbers

Formatting phone numbers using Flash Fill

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close