You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.
Flash fill is a great Excel tool. Learn how to use flash fill to automatically extract data, combine data, and much more.
In order to use Flash Fill, Excel must be able to understand a pattern in a column to the left of the column where you want to fill the data so the source data should be entered in a consistent way. You can use Flash Fill by clicking a button, using shortcuts or by using the Fill handle.
In this article, we learned how to use the flash fill in excel and autofill hundreds of rows in seconds. We also saw the advanced use of the Autofill feature in sorting data in an Excel spreadsheet.