How to Enable and Use Flash Fill in Excel
Question details
The user wants to enable Excel Flash Fill and use it to complete values based on examples.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to extract or reformat data in a neighboring column without entering every value manually.
- Observed behavior
- Flash Fill recognizes a pattern from entered examples and fills the remaining cells when Excel can identify the intended result.
Check that the source data is arranged in a column and that an adjacent column is available for the results. Flash Fill is available in supported versions of Excel, including Excel 2013 and later.
Enter an Example and Run Excel Flash Fill
Use Flash Fill to complete a column from a pattern in your source data.
In a cell next to the source data, type the result you want. For example, if A2 contains a full name, enter the first name in B2.
Click the next cell in the results column, such as B3. If needed, enter another example to make the pattern clearer.
On Windows, press Ctrl+E, or choose Data > Flash Fill. Excel fills the remaining cells when it recognizes the pattern.
Check the completed cells against the source column. Correct the examples and run Data > Flash Fill again if the results are not what you expected.

Enable Automatic Flash Fill in Excel for Windows
Use this setting if you want Excel to suggest Flash Fill results automatically as you type.
Work with Spreadsheet Data in WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface. Open compatible Excel workbooks and use spreadsheet formulas to work with data as you migrate between office suites.

Frequently Asked Questions
Where is the Flash Fill command in Excel?
Select a cell in your results column, then choose Data > Flash Fill. In Excel for Windows, you can also press Ctrl+E.
Why isn't Excel suggesting Flash Fill results automatically?
In Excel for Windows, check File > Options > Advanced > Editing options and enable Automatically Flash Fill. You can also run it manually from the Data tab.
What should I do if Flash Fill produces the wrong pattern?
Correct or add another example in the results column, select the next cell, and choose Data > Flash Fill again. Review the results before using them.
Does Flash Fill update when the original data changes?
No. Flash Fill inserts values rather than formulas. Run Data > Flash Fill again or use formulas if you need results that update with the source data.




