Microsoft Excel: How to Turn Off Flash Fill

To turn off automatic Flash Fill in Microsoft Excel for Microsoft 365 on Windows, go to File > Options > Advanced, clear Automatically Flash Fill under Editing options, and select OK. Excel will stop filling in pattern-based suggestions automatically, but you can still run Flash Fill manually from the Data tab when you want it.

Turn Off Automatic Flash Fill in Excel for Windows

The setting is in Excel’s application options, rather than in a particular worksheet or workbook. Follow these steps in the desktop version of Excel for Microsoft 365 on Windows:

Select File in the ribbon.
Select Options near the bottom of the backstage menu. If the Options button is not visible, maximize the Excel window or look at the bottom of the left-hand menu.
In the Excel Options window, select Advanced.
Under Editing options, clear the checkbox labeled Automatically Flash Fill.
Select OK to save the change and return to the worksheet.

The change takes effect for subsequent editing in Excel. You do not need to restart the program or alter existing cells. If you later want automatic suggestions back, repeat the same steps and select the checkbox again. The setting is not saved as a property of an individual workbook, so changing it affects how Excel behaves across the workbooks you edit in that installation and user profile.

What the Automatic Flash Fill Setting Controls

Flash Fill looks for a pattern in the values you enter and offers to complete similar values in nearby rows. Turning off Automatically Flash Fill stops Excel from offering or inserting those automatic pattern-based results as you type. It does not delete data already filled, change formulas, or prevent you from using the manual Flash Fill command.

For example, suppose column A contains full names such as Jordan Lee and Priya Shah. If you type Jordan in the adjacent column, Excel may recognize that you want first names and preview matching first names for the remaining rows. With automatic Flash Fill turned off, Excel will not automatically act on that pattern. You can still enter the results yourself or deliberately request Flash Fill from the ribbon.

This setting is useful if Excel’s suggestions interrupt your typing, if it guesses the wrong pattern, or if you prefer to control every value added to a sheet. It is also helpful when several transformations are plausible. A list of product codes, for instance, might be split at a dash in more than one way; a guess that looks reasonable for the first few rows may not match what you intend for every row.

How Flash Fill Recognizes a Pattern

Flash Fill is designed for transformations that can be demonstrated by examples. You type one or more results beside the source data, and Excel tries to infer the operation from those examples. It can often extract part of a text value, combine pieces, change capitalization, or reformat a string. It is not a formula: the results it supplies are values, not expressions that recalculate when the source changes.

Consider email addresses in column A and a blank column B. If you enter the portion before the at sign for one or two rows, Flash Fill may infer that you want the username from each address. For dates stored as text, you might demonstrate a consistent rearrangement of components. For names, you might provide a first name, last name, or initials as the sample output. The quality of the suggestion depends on how clearly the examples express the same rule.

Flash Fill is not a general-purpose data-cleaning engine. It does not understand the meaning of your records, and a pattern that works for most rows can fail on exceptions such as middle names, suffixes, missing values, or inconsistent punctuation. Inspect the full output before relying on it, especially for a large list or information that will be imported into another system.

Use Flash Fill Manually After Turning Automation Off

Disabling automatic Flash Fill does not remove the feature. To use it on purpose, enter an example in the column where you want the result, select the next cell in that output range, and choose Data > Flash Fill. On Windows, the keyboard shortcut is Ctrl+E. Excel will attempt to complete the remaining rows using the pattern it detects.

For a more reliable result, provide more than one example when the data is irregular. If you want to create a display name from first and last names, a single example may be enough when every row follows the same layout. If some people have middle names or suffixes, examples covering those cases can help show the intended result, but you should still review the output row by row. You can undo a just-applied Flash Fill with Ctrl+Z on Windows if it produces an unwanted result.

Manual use is a practical middle ground: Excel does not interrupt your normal entry, yet the command remains available for quick, one-time transformations. Remember that the resulting values do not update if you later edit the source cells. If the source data is likely to change, a formula or a repeatable data transformation may be a better choice.

Excel for Mac and Excel for the Web

In Excel for Mac, look in Excel’s application settings for an editing option named Automatically Flash Fill. Depending on the Excel release, the menu may be labeled Excel > Settings > Edit or, in older releases, Excel > Preferences > Edit. Clear the same checkbox if it is present. Menu labels and the placement of settings can vary between Mac versions, so use the Excel settings search or help if you do not see the option.

The Data tab may also provide a manual Flash Fill command in desktop Excel for Mac. Its shortcut can differ from the Windows shortcut based on the keyboard and Excel version, so use the ribbon command if a shortcut is not recognized. Do not assume that pressing Ctrl+E on a Mac will behave just as it does on Windows.

Excel for the web has a different feature set and interface from the desktop application, and the automatic Flash Fill control may not be available there. If you cannot find the setting in a browser, open the workbook in the desktop Excel app and change it there. This setting controls Excel’s behavior, not the workbook’s stored data, so opening a file in a different application does not itself remove values previously generated by Flash Fill.

When Flash Fill Does Not Behave as Expected

If Excel keeps making automatic suggestions after you think you turned Flash Fill off, check that you cleared the correct setting. The relevant checkbox is Automatically Flash Fill under File > Options > Advanced > Editing options; it is not the same as cell autocomplete. Also make sure the change was confirmed with OK, rather than dismissed from the options window.

If the checkbox is already clear but you still see suggested or completed text, consider what kind of behavior you are seeing. Excel’s cell autocomplete can offer a previous entry that begins with the same characters as your current entry. That feature may look like Flash Fill, but it is different: autocomplete uses existing entries in the same column, while Flash Fill infers a transformation from examples in adjacent data.

When Flash Fill does not appear to run, the data may not show a consistent pattern, or Excel may not have enough examples to infer one. Enter the desired result in a few rows, check that the examples follow the same rule, and then use Data > Flash Fill. Make sure the output column is next to the source data and that there is room for the results. If Excel fills only some rows or makes incorrect choices, correct the results manually or choose another method rather than assuming the output is complete.

Flash Fill, Cell Autocomplete, and Formulas Are Different

Several Excel features can appear to complete data, but they solve different problems. Knowing which one is responsible makes it easier to switch off the behavior you do not want without losing a useful tool.

Flash Fill infers a transformation from examples, such as extracting a first name from a full name. The automatic behavior is controlled by the Automatically Flash Fill option.
Cell autocomplete suggests an existing entry when you start typing a value already present in the same column. In Windows Excel, its setting is File > Options > Advanced, under Editing options, labeled Enable AutoComplete for cell values.
Formulas calculate results according to instructions you enter. They can update when their referenced cells change, unlike Flash Fill’s static output values.
Fill Handle and Fill commands extend values, series, or formulas by dragging or using fill options. These are separate from Flash Fill’s pattern recognition.

For example, typing a familiar department name that already appears above may trigger cell autocomplete. Typing a shortened version of a name in a neighboring column and seeing Excel infer the same extraction for other rows points to Flash Fill. Disabling the Flash Fill checkbox will not necessarily stop cell autocomplete, and disabling autocomplete does not turn off Flash Fill.

Alternatives for Repeatable or More Exact Results

Flash Fill is convenient for a quick transformation, but it is not always the best tool. If the source values change regularly, a formula can make the relationship explicit and recalculate results. If the task involves many files or several cleaning steps, Power Query can provide a repeatable workflow. For a small one-off task, direct editing may be clearest, particularly when exceptions need individual judgment.

Choose an approach based on how often the task will recur and how predictable the input is:

Use a formula when results should change along with their source cells or when you need a visible, auditable rule. Select a formula appropriate to the data and Excel version available.
Use Power Query when you repeatedly import and reshape tables, such as splitting a column, removing spaces, or combining files. A saved query can be refreshed when the source data is updated.
Use Flash Fill manually for a fast, one-time pattern-based result that you can inspect immediately.
Edit values directly when the list is short or full of exceptions that are difficult to describe consistently.

Whichever method you choose, keep the original data until you have checked the result. A safe workflow is to put transformed values in a new column, compare representative rows—including unusual cases—and only then decide whether to replace or remove the source column. This is especially important because Flash Fill’s output does not preserve a live link to the original values.

Frequently Asked Questions

Does turning off Flash Fill delete results already in my worksheet?

No. Turning off automatic Flash Fill changes Excel’s future behavior; it does not clear cells or reverse transformations already made. If you want to remove existing results, select those cells and edit or clear them yourself. If the fill just happened, Undo may reverse the action.

Can I use Flash Fill after disabling it?

Yes. The option disables automatic Flash Fill, not the manual command. Enter examples and use Data > Flash Fill, or press Ctrl+E in Excel for Windows. Review the generated values because Excel may misread exceptions.

Is Flash Fill setting saved in each workbook?

No. The Automatically Flash Fill checkbox is an Excel application setting, not a worksheet-level control that travels with a workbook. Changing it affects how Excel behaves for your account and installation, while the data already in a workbook remains there.

Why does Excel still complete text after I turn off Flash Fill?

You may be seeing cell autocomplete rather than Flash Fill. Autocomplete suggests existing entries from the same column; Flash Fill infers a pattern from examples, commonly in an adjacent column. In Windows Excel, cell autocomplete has its own checkbox under File > Options > Advanced.

Can I turn off Flash Fill for just one worksheet?

There is no worksheet-specific switch for the automatic Flash Fill setting in desktop Excel for Windows. You can turn automatic Flash Fill off for Excel, then run the manual command only on the sheet and range where you need it. That gives you control over when the transformation is applied without relying on automatic suggestions.

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.