A feature that automatically fills data in a column by detecting patterns in your manual entries.
Try it with AIFlash Fill analyzes the data you are typing and suggests a pattern to complete the rest of the column instantly. It is triggered by pressing Ctrl+E or by typing in the cell directly below your examples. It is ideal for splitting names, formatting phone numbers, or extracting specific text strings without complex formulas.
If column A contains 'John Doe' and you type 'John' in column B, Flash Fill will suggest 'Jane', 'Bob', etc., for the remaining rows when you press Ctrl+E.
You can trigger it by pressing Ctrl+E on your keyboard or by going to the Data tab and clicking the Flash Fill button.