Excel Flash Fill Not Working? Causes, Fixes, and Tips

Errors & fixes · Updated November 21, 2026

If Excel Flash Fill is not working, enter a clear example beside the original data, then choose Data > Flash Fill or press Ctrl+E in Excel for Microsoft 365 on Windows. If nothing happens, check that automatic Flash Fill is enabled, that Excel can recognize a consistent pattern, and that you are using the desktop app rather than Excel for the web.

What Flash Fill does—and what it does not do

Flash Fill recognizes a pattern in examples you type and uses it to fill similar results down a column. For example, if column A contains full names and you type a first name in column B, Flash Fill may recognize that you want the first name from each entry. It can also combine text, change letter case, or rearrange parts of a value.

Unlike a worksheet formula, Flash Fill writes ordinary values into the cells. The results do not recalculate if you later change the source data. That makes it useful for a one-time cleanup or reshaping task, but less suitable for a worksheet that must remain linked to changing inputs. It is also different from AutoFill, which extends a sequence, copies a formula, or repeats a value by dragging a cell’s fill handle.

Try the standard steps first

Use a simple example and leave the source data intact until you have checked the output. In this example, full names are in column A and the desired first names will go in column B:

  1. In B2, type the first name from A2, matching the result you want.
  2. Press Enter, then begin typing the next result in B3. If Excel shows a preview of the remaining entries, press Enter to accept it.
  3. If no preview appears, select the blank cells below the example in column B and press Ctrl+E, or choose Data > Flash Fill.
  4. Review several results, including entries near the bottom of the data, before using them elsewhere.

For example, if A2 contains Jordan Lee and A3 contains Priya Shah, typing Jordan in B2 and Priya in B3 can show Excel that you want first names. The preview is a suggestion, not a guarantee that every row has the same structure. For a one-off task, selecting the output range and using the ribbon command is often clearer than waiting for a preview.

Check the automatic Flash Fill setting

On Windows, automatic suggestions can be disabled even though the manual command is available. To check the setting in Microsoft 365, open File > Options > Advanced. Under Editing options, make sure Automatically Flash Fill is selected, then select OK. Return to the sheet and try typing a second example again.

This setting controls whether Excel offers a fill automatically as you type; it does not mean you must use the suggestion. You can still invoke Flash Fill manually with Ctrl+E or Data > Flash Fill when the feature is available. If you use a managed work computer and cannot change the setting, an administrator policy or restricted installation may be involved.

Give Excel a pattern it can recognize

Flash Fill is pattern recognition, not a rule editor. A single example may be enough for uniform entries, but two or more examples can clarify what you mean. If Excel joins the wrong parts or chooses the wrong name, undo the fill, provide examples that demonstrate the intended result, and run it again.

Consider product codes such as AB-104-blue and CD-208-green. If the desired output is the middle number, examples showing 104 and 208 make the pattern more apparent. If some rows use a different separator, omit a component, or contain extra spaces, Excel may not apply one consistent transformation to all rows. Clean or separate those exceptional records first, or use a formula or other deliberate method when the rule must be exact.

Flash Fill also depends on the nearby data being useful as context. Put the example results in a neighboring column and keep the source column visible. If the intended output combines information from several columns, provide examples that make clear which pieces to include and in what order. When the result is ambiguous—for instance, extracting a name from a sentence that contains several names—more examples may still not resolve every case reliably.

Common reasons Flash Fill seems broken

  • No example was entered: Flash Fill needs an example of the result, rather than just a selected empty column. Type the desired output first.
  • The destination selection is wrong: Select the output cells where you want results, or start typing in the adjacent output column. Make sure the selection does not include unrelated data you do not want replaced.
  • The pattern varies: Mixed formats, inconsistent separators, blank source cells, and exceptions can confuse the preview or produce incomplete results. Inspect the original rows for differences.
  • There is no preview: Automatic Flash Fill may be off, or Excel may not be confident about the pattern. Try the manual command after adding a second example.
  • The command is unavailable: You may be using Excel for the web, an older or restricted installation, or a ribbon layout in which the command is not visible. Confirm that you are in desktop Excel and check the Data tab.
  • Nothing seems to change: The result might already be present, the selected cells may not be the intended destination, or the pattern may not yield a detectable transformation. Test with a small, obvious example in a blank neighboring column.

Windows, Mac, and Excel for the web

These steps are for Microsoft 365 desktop Excel on Windows. The Windows shortcut is Ctrl+E. On a Mac, use the Data tab’s Flash Fill command when it is available in your Excel version; keyboard shortcuts can differ by version and keyboard settings, so the menu command is the dependable route. If the command is missing, check that Excel is updated and that your version includes the feature.

Excel for the web does not provide the same desktop Flash Fill command. If you are working in a browser, open the workbook in the desktop app if you have access to it. Otherwise, use a formula or perform the transformation in another supported way. Menu and feature availability can differ across editions, so do not assume a shortcut from Windows will work in a browser or on a Mac.

Flash Fill compared with formulas and AutoFill

Choose the method based on whether your results need to change when the source changes. Flash Fill is convenient for static cleanup: it quickly creates values from a recognizable sample, but leaves no formula that explains or updates the transformation. AutoFill is useful for copying an existing formula or continuing a recognizable series, but it does not infer a text transformation from examples in the way Flash Fill does.

A formula is often preferable when data is added regularly or results must stay synchronized with their source. For example, a formula can extract text according to a clear delimiter rule and recalculate when the source changes. Formulas may take more setup, particularly when records are irregular, but their logic is visible in the cell and can be audited. For a one-time conversion, you may use Flash Fill and then review or copy the results as values; remember that Flash Fill’s output is already stored as values, not live links.

For larger or repeatable data-cleaning jobs, Power Query can provide a more repeatable transformation process than manually invoking Flash Fill. It has a different learning curve and is unnecessary for many small lists. A practical rule is: use Flash Fill for a quick, checked, one-time pattern; use formulas or a repeatable transformation when the source may change or accuracy must be consistent every time.

Check results and recover from a bad fill

Flash Fill can produce plausible but incorrect values, especially when names or codes follow more than one format. Do not treat a preview as validation. Compare a sample from the top, middle, and end of the list with the source, and pay special attention to rows with initials, multiple spaces, missing fields, or unusual punctuation. If the output is important, check every row or use a method with explicit rules.

If the output is wrong immediately after the operation, press Ctrl+Z on Windows to undo it, then add clearer examples or choose another method. On a Mac, use Command+Z to undo. If you have continued editing since the fill, undo may also reverse later work, so consider saving a copy before making broad changes. Flash Fill does not alter the source column when you direct it to a separate destination column, which is another reason to keep the original data during cleanup.

Frequently Asked Questions

What is the keyboard shortcut for Flash Fill in Excel?

In Excel for Microsoft 365 on Windows, the shortcut is Ctrl+E. You can also choose Data > Flash Fill. On a Mac, use the ribbon command if available because shortcuts may differ; Excel for the web does not offer the same desktop command.

Why does Excel Flash Fill not show a preview?

The automatic setting may be off, or Excel may not recognize your intended pattern from the examples. On Windows, check File > Options > Advanced and enable Automatically Flash Fill. Then type another clear example or run Data > Flash Fill manually.

Does Flash Fill update when I change the original data?

No. Flash Fill inserts values rather than formulas, so changing a source cell does not update the corresponding result. Run Flash Fill again or use a formula or repeatable data transformation if results need to stay current.

Can I use Flash Fill in Excel for the web?

The desktop Flash Fill command is not available in Excel for the web. Open the file in desktop Excel to use Flash Fill, or use a formula or another suitable method in the browser.

Why does Flash Fill give the wrong results?

It may have inferred a different pattern than the one you intended, especially if entries have inconsistent formats or exceptions. Undo the result, provide additional examples that show the exact output you want, and check the filled rows before relying on them.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.