Question

what is the difference between Auto fill and flash fill​

Answer 1

Answer:

Flashfill 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.

Autofill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the values from other cells. In other words, Excel compares the selected data and tries to guess the next values that will be inserted.

Answer 2

Answer:

Flash fill auto fills your data when it senses a pattern where as auto fill allows you to create entire column or rows based on data from other cell and not from the pattern.