Remove Flash Fill in Excel: Clear Results or Turn It Off

How-to basics · Updated November 21, 2026

To remove Flash Fill results, select the cells Excel filled and choose Home > Clear > Clear Contents, or press Delete on Windows. To stop Excel from filling automatically, go to File > Options > Advanced and clear Automatically Flash Fill. These are separate actions: turning the feature off does not erase results already in your worksheet.

What does remove Flash Fill mean?

People usually mean one of two things when they ask how to remove Flash Fill in Excel. They may want to erase values that Flash Fill has already put into cells, or they may want Excel to stop suggesting or applying Flash Fill when they type. Choose the action that matches the problem: clearing cells removes existing output, while changing an option prevents automatic filling in the future.

Flash Fill recognizes a pattern in your examples and fills nearby cells to match it. For example, if a column contains full names and you type the first person’s first name in the next column, Excel may infer that you want first names for the other rows. It can also help split text, combine pieces, change capitalization, or extract parts of an email address.

Unlike a formula, a Flash Fill result is normally a value in the cell, not a live instruction tied to the source. If the original full name changes later, a previously filled first name generally does not update to match. This distinction matters when deciding whether to clear the results, keep them, or replace them with another method.

Delete Flash Fill results without changing the source

First identify which cells contain the generated output. If column A has full names and column B has the extracted first names, select the filled cells in column B—not the original names in column A. Then use one of these methods:

  • On Windows, press Delete after selecting the output cells. This removes their contents but normally leaves cell formatting in place.
  • Use Home > Clear > Clear Contents to remove the selected cell contents while preserving formatting.
  • If you also want to remove formatting, use Home > Clear > Clear All. Be careful: this clears more than the text or values.

To select a continuous block, click its first output cell, then hold Shift while clicking the last one. For a large column, you can select the relevant range by clicking and dragging or by using the Name Box to enter a range such as B2:B500. Check the selection before clearing it, especially if the source and results sit next to each other.

Clearing cells does not delete the worksheet column, remove the original data, or switch Flash Fill off. If the results are in an Excel table, clearing their contents leaves the table structure in place. If you used Flash Fill in several separate ranges, clear each output range individually.

Turn off automatic Flash Fill in Windows

In Excel for Microsoft 365 on Windows, use this setting to prevent automatic Flash Fill suggestions:

  1. Select File > Options.
  2. Choose Advanced in the Excel Options window.
  3. Under Editing options, clear Automatically Flash Fill.
  4. Select OK.

This setting controls Excel’s automatic response when it detects a pattern as you enter data. It does not remove existing filled values. It also does not prevent you from deliberately requesting Flash Fill with the command or keyboard shortcut, so use the manual command carefully if your goal is to avoid the feature altogether.

If you want to use automatic Flash Fill again, return to the same setting and select Automatically Flash Fill. The checkbox is an application option, not a command that changes only the active cells. If you work in more than one Excel installation or device, check the setting on the one where the behavior is happening.

Turn off automatic Flash Fill on Mac or use Excel for the web

In Excel for Mac, open Excel > Preferences (called Settings in some releases), choose Edit, and clear Automatically Flash Fill if that option is shown. Menu labels can vary slightly by Excel release. As on Windows, changing this preference does not clear values already in the sheet.

Flash Fill is a desktop Excel feature. Excel for the web may not offer the same Flash Fill command or preference. If you cannot find the option while working in a browser, open the workbook in the desktop app and make the change there. Clearing existing results in the browser is a separate matter: select the cells and use the available clear-contents command, taking care not to select the source data.

Use Flash Fill manually when automatic filling is off

Turning off automatic Flash Fill does not necessarily remove the manual command. In desktop Excel for Windows, enter an example beside your source data, select the cells where you want the pattern completed, and choose Data > Flash Fill. The Windows keyboard shortcut is Ctrl+E. On Mac, use Control+E where the shortcut is supported, or choose Data > Flash Fill from the ribbon.

For instance, suppose A2 contains Jordan Lee. If you type Jordan in B2, then request Flash Fill for the rest of column B, Excel may infer that the desired output is each person’s first name. Review the results before relying on them. If names have different formats, such as a middle initial, a suffix, or a single name, one pattern may not produce the intended answer for every row.

Flash Fill may offer a preview after you type an example. Press Enter to accept a suggestion when it is correct. If it is not what you want, undo the suggestion or clear the generated cells and provide a more representative example. A carefully chosen example can help, but it cannot guarantee that Excel will understand every exception in a messy dataset.

What happens to source data and later edits?

Flash Fill reads the examples and nearby data to infer a pattern; it does not usually create a continuing link between the input and output. This makes it convenient for a one-time cleanup or for preparing a fixed list to export. It also means that a result can become outdated if the source changes. For example, changing Jordan Lee to Jordan Kim will not reliably update a previously generated Jordan or extracted surname.

Before deleting or replacing a Flash Fill result, consider whether another part of the workbook depends on it. A chart, lookup, or later calculation might use those cells. Clearing the results could leave those downstream items blank or produce errors. If the output is important, save a copy of the workbook or copy the results elsewhere before clearing them.

Flash Fill can also produce text that looks like a number, date, or code. This is useful when you need an exact text string, but it can affect sorting, arithmetic, or leading zeros. For example, a generated code such as 00421 should be checked carefully if the zeros are meaningful. Confirm the cell values and formats before using the results for reporting or importing into another system.

Common problems when removing or stopping Flash Fill

  • The results remain after switching it off: That is expected. The preference affects future automatic filling; clear the existing output cells separately.
  • Excel fills cells again after you delete them: If automatic Flash Fill remains enabled, entering another example can trigger a new suggestion. Disable the setting before continuing to edit if that behavior is unwanted.
  • The wrong cells disappear: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if the undo action is still available. Then select only the output range and clear it again.
  • Some rows are wrong even though most look right: Flash Fill follows inferred patterns, not a set of rules you have explicitly defined. Inspect unusual names, punctuation, extra spaces, blank rows, and inconsistent date or code formats.
  • You cannot find the setting: Check that you are using desktop Excel and look under the Advanced editing options on Windows. Mac labels and available controls can differ by release.

A common misconception is that Flash Fill is a formula feature that must be removed from the formula bar. Usually it is not: the generated entries are values. If a selected result does show a formula in the formula bar, it may have been created by a formula or another method instead, so inspect the cell before clearing a large range.

Flash Fill, formulas, and other ways to clean data

Flash Fill is useful when you need a quick, one-time transformation and can visually verify the output. Its main trade-off is that the pattern is inferred and the resulting values do not automatically follow later changes to the source. For a small list of consistently formatted names or labels, that may be exactly what you need.

Use a formula when the output should update as source data changes, or when you need repeatable logic that can be checked and copied consistently. Text functions can split or join strings, but the right approach depends on the Excel version and on whether the source values have a dependable format. For recurring imports or complicated cleanup, Power Query may be a better fit because its transformation steps can be refreshed. These alternatives take more setup than Flash Fill, but they make the process easier to reproduce.

There is no need to replace Flash Fill just because it is automatic. A practical choice depends on the task:

  • Choose Flash Fill for a quick, reviewed, one-time result.
  • Choose a formula when results need to recalculate from changing source cells.
  • Consider Power Query for repeatable, multi-step cleanup of imported data.
  • Keep the original column until you have checked the output and confirmed that other workbook content does not rely on it.

Frequently Asked Questions

Does turning off Flash Fill delete the data it already created?
No. It stops automatic Flash Fill behavior, but existing results stay in their cells. Select those output cells and clear their contents if you want to remove them.

How do I remove Flash Fill from just one column?
Select only the generated cells in that column, then choose Home > Clear > Clear Contents or press Delete on Windows. Do not include the source column in your selection.

Can I undo Flash Fill?
Yes, use Ctrl+Z on Windows or Command+Z on Mac soon after it happens. If you have performed other actions since then, undo may reverse those actions too; selecting and clearing the output range is often more precise.

Why does Excel keep suggesting Flash Fill?
Automatic Flash Fill may still be enabled. On Windows, clear Automatically Flash Fill under File > Options > Advanced. On Mac, check Excel > Preferences or Settings > Edit.

Are Flash Fill results formulas?
Normally, no. Flash Fill writes values based on a pattern it infers, so those values do not automatically update when the source changes. Check the formula bar if you are unsure how a particular cell was created.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.