Function Problems

How to Enable and Use Flash Fill in Excel

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

The user wants to enable Excel Flash Fill and use it to complete values based on examples.

How to Enable and Use Flash Fill in Excel
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.
Before you start

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.

Solution 1Recommended

Enter an Example and Run Excel Flash Fill

Use Flash Fill to complete a column from a pattern in your source data.

1
Enter an example

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.

2
Select the next cell

Click the next cell in the results column, such as B3. If needed, enter another example to make the pattern clearer.

3
Run Flash Fill

On Windows, press Ctrl+E, or choose Data > Flash Fill. Excel fills the remaining cells when it recognizes the pattern.

4
Review the results

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.

Enter an Example and Run Excel Flash Fill
Results do not update automatically: Flash Fill produces values rather than formulas, so rerun it if the source data changes.
Free Microsoft Office alternative

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.

Use formulas such as LEFT and RIGHT to extract text from spreadsheet cellsOpen and edit compatible Microsoft Excel XLS and XLSX filesNavigate spreadsheets with a familiar office-style interfaceMove between office suites with support for common document formats
microsoft office alternative - wps office

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.