Question

what is the difference between flash fill and fill handle

Answer 1

Answer:

Flash Fill is a close relative of Auto Fill, but it performs a slightly different function. Rather than continuing a series of data, it can source information from other cells and present it with your desired formatting.

Answer 2

Fill Handle in excel is used for filling up the data by creating a series of value which either follow a pattern or we can check if the values we entered are of series or not. It is very easy to implement. Fill Handle is available at the right bottom of any cell. Enter some values such as number or alphabets or dates in at least 3 cells to have a pattern. Select the cells with values and then either drag the Fill Handle or double click will also work here.



Flash Fill is a data tool in Microsoft Excel that will allow you to combine, extract or transform data based on a few examples.
You only need to provide a couple examples of the results you want. Excel will guess the pattern and fill in the rest of the data for you.

It automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.