How to Use Flash Fill in Microsoft Excel
To use the Flash Fill feature in Microsoft Excel, follow these steps:
Open the Excel spreadsheet that you want to use.
In the column next to the column that contains the data you want to fill, type the new data that you want to use.
Make sure that the new data follows the same pattern as the existing data.
Click the Data tab on the ribbon, then click the Flash Fill button.
Excel will automatically fill in the rest of the column with the new data, using the pattern you provided.
Note: Flash Fill is not available in all versions of Excel. If you don't see the Flash Fill button on the Data tab, you may need to update your version of Excel or enable the feature in the Excel Options menu.
And if this article about How to Use Flash Fill in Microsoft Excel hasn't satisfied you yet, you can watch the video below.
That's all from SmashinGeeks, see you in another article. ^^