Question

How the autofill feature differs from the flash fill feature in excel? do not answer if you do not know please

Answer 1

Explanation:

Because the characters in cell A1 are all uppercase, and the characters in cell A2 are all lowercase, Microsoft Excel determines that row 1 is a list header row. The algorithm for the Auto-Complete feature does not generate suggested text if the first row is considered a list header row.