What is flash fill in excel

Flash Fill 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.

1. What is the difference between Flash Fill and autofill in Excel?
2. What is the difference between flash fill and the fill handle?

What is the difference between Flash Fill and autofill in Excel?

While it's true that the Auto Fill feature is able to copy a pattern, it is limited to repeating a simple pattern over and over. Flash Fill is a smarter tool: It has the capability to foresee which adjustments within a pattern the user is attempting to make within a spreadsheet.

What is the difference between flash fill and the fill handle?

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.