top of page

Excel's Fantastic Flash Fill. Magic!

Updated: Jun 28, 2023

Excel's Flash Fill feature is a powerful tool that allows you to quickly fill in a range of cells with data that follows a pattern.
Excel Flashfill Example

Here's how to use it:


Start by entering a few examples of the data you want to fill in the cells.





Excel Flashfill Example

Select the cell where you want to start the fill, then click the "Flash Fill" button on the "Data" tab of the ribbon.






Excel Flashfill Example
Excel Flashfill Example










You can also use the keyboard shortcut "Ctrl + E" to trigger the Flash Fill.




Excel Flashfill Example




Excel will automatically fill in the rest of the cells with data that follows the pattern you

entered.

Excel's Flash fill Button

A 'Flash Fill Options' button will

appear in the adjacent column.



Excel Flashfill Example




If Excel is unable to fill the cells correctly, you can click the "Flash Fill Options" button to choose the correct pattern.




If you need to make changes to the data that was filled in, you can do so by editing the cells directly. Flash Fill does not overwrite the original data, so your changes will not affect the pattern used to fill the cells.


You now have your data auto-populated using Flash Fill.


What is very impressive is Excel was able to apply the same format pattern to the rest of the table without the use of a single formula!

How easy is that!?



 

Comdex Training News & Blogs 2023


165 views1 comment

Recent Posts

See All

1 Comment


I would like to advise you to add an explanation video to your tutorial format. You can use https://www.movavi.com/screen-recorder/. This will greatly improve your content.

Like
bottom of page