top of page


In my humble opinion, acquiring knowledge of when and how to utilize this tool can greatly save you time.

Flash Fill is employed to extract or combine data from one or more cells based on a pattern.

To utilize Flash Fill, all you need to do is provide Excel with an example. Based on this example, Excel automatically carries out the same action for the remaining data. It does this by analyzing the provided example, recognizing the pattern, and comprehending the logic required for subsequent rows.

The shortcut for the Flash Fill is: Ctrl + E.

bottom of page