Excel Flash Fill: How to Disable Automatic Suggestions

To disable automatic Flash Fill in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, clear Automatically Flash Fill under Editing options, and select OK. This stops Excel from automatically suggesting or completing Flash Fill patterns; you can still run Flash Fill yourself with Data > Flash Fill or Ctrl+E.

Disable automatic Flash Fill in Excel

The setting is an Excel application option, rather than a switch stored only in the workbook you currently have open. To change it in the Windows desktop version, follow these steps:

Select File, then Options. If the workbook is in full-screen view, press Esc first to return to the normal window.
In the Excel Options window, select Advanced.
Under Editing options, find Automatically Flash Fill and clear its checkbox.
Select OK to save the preference.

The checkbox controls automatic recognition and filling. Turning it off does not remove existing values from worksheets, change formulas, or prevent you from choosing the command when you want it. If Excel keeps completing patterns after you clear the option, check that the change was saved and that you are using the same Excel installation or user profile where you changed it.

What the setting changes—and what it does not

Flash Fill recognizes a pattern in data you enter and uses it to fill nearby cells. For example, if column A contains full names and you type a person’s first name in column B, Excel may notice the pattern and offer first names for the remaining rows. With automatic Flash Fill enabled, Excel can complete the column as you enter the example. Clearing the setting prevents that automatic behavior from interrupting your typing.

The key distinction is between automatic and manual Flash Fill. The preference is named Automatically Flash Fill, and disabling it does not disable the Data tab command. When you deliberately select Flash Fill, Excel still tries to infer the pattern from your examples and populate the selected area. This is useful if you only want to avoid unsolicited completions, not give up the feature entirely.

Flash Fill also does not create a formula that recalculates when the source changes. It writes the results as ordinary values. If you extract a first name from a full name and later correct the full name, the extracted value will not automatically update. That difference matters when choosing between Flash Fill and a formula-based solution.

How Flash Fill recognizes a pattern

Flash Fill looks for a repeatable relationship between the data you provide and the examples you type. It can often separate parts of text, combine text from multiple columns, or change a recognizable format. For instance, given a column of email addresses, you might type the part before the at sign in a neighboring column. After one or more examples, Excel may identify the pattern and offer matching results for the other rows.

It is pattern-based rather than a fully specified data-cleaning rule. Excel does not know what you intend in the way a person might, and a pattern that fits the first few rows may not fit every row. Names with middle initials, inconsistent spacing, suffixes, or different ordering can make a name-splitting pattern ambiguous. A few examples can also be insufficient to distinguish between two possible transformations.

Before accepting a suggested fill, scan the proposed results, especially at the bottom of a long list and around rows with unusual values. If the pattern is wrong, undo the fill immediately with Ctrl+Z, add better examples, or use a more explicit method. Disabling automatic Flash Fill can reduce accidental fills, but it does not make manually requested Flash Fill more accurate.

When turning automatic Flash Fill off makes sense

Automatic completion can be convenient when a worksheet contains consistent text and the intended pattern is obvious. It can also be distracting when you are entering data in a particular sequence, working with irregular records, or want to inspect each result before filling a whole column. Turning off the automatic option gives you a deliberate choice about when to apply it.

You are entering exceptions. A column may contain a mix of names, codes, and notes. A fill based on the first few rows might not suit later entries.
You need to preserve exact text. Identifiers, account codes, and product numbers can have leading zeroes or meaningful punctuation. Check that a suggested result keeps the exact characters you need.
You are editing a shared or operational workbook. Automatic changes may surprise someone who expects to review or enter values in a particular way.
You want predictable data entry. If you are typing a series of examples to build a rule, automatic completion may get in the way before you have finished describing the pattern.

Disabling the option is not a security feature and does not protect cells from changes. It simply changes Excel’s automatic behavior. If you need to restrict edits, use appropriate worksheet protection and sharing controls rather than relying on the Flash Fill setting.

Use Flash Fill manually when you choose

After switching off automatic Flash Fill, you can still invoke it for a particular transformation. Put the source data in one column and type one or more examples in an adjacent column. Select the destination cells that should receive results, then choose Data > Flash Fill. In many cases, you can instead select the first destination cell and press Ctrl+E on Windows.

For example, suppose A2:A6 contains full names and you want first names in B2:B6. Type the intended first name for the first record in B2. If the names are consistent, selecting the destination range and using Flash Fill can complete the remaining entries. Check every result rather than assuming that the first example defined the rule unambiguously.

Flash Fill works best when the examples make the transformation clear and the source entries are reasonably consistent. If the suggested results are incomplete, enter another correct example and try again. If the output still does not match your rule, undo it and use a formula, a text function, or Power Query instead. Flash Fill is a convenience for transforming a set of values, not a substitute for validating important data.

Excel for Mac and Excel for the web

In Excel for Mac, Flash Fill is available in supported desktop versions. The preference is generally under Excel > Preferences > Edit, where you can clear Automatically Flash Fill if that option appears in your version. The available settings and labels can vary by release. You can also look for Data > Flash Fill to run the command manually; keyboard shortcuts may differ depending on the keyboard and macOS settings.

Excel for the web does not provide the same desktop Flash Fill workflow and options. If you need the desktop command or its automatic-fill preference, open the workbook in the Excel desktop app. If you are using a different desktop release and cannot find the checkbox, search Excel Options for the Advanced editing settings, or check whether your organization manages Office settings centrally.

These differences matter because a workbook can be opened in more than one Excel environment. The automatic Flash Fill preference controls behavior in the desktop application where it is set; it is not a workbook rule that guarantees identical behavior for every person who opens the file.

Troubleshoot unexpected Flash Fill behavior

If Excel still seems to fill data after you have disabled the automatic option, first identify what actually changed. Flash Fill produces fixed values, while formulas recalculate and may look like automatically completed text. Select one of the results and inspect the formula bar: if it begins with an equals sign, it is a formula, not a Flash Fill result. You can also use Ctrl+Z straight away if an unwanted fill has just happened.

Check the exact checkbox. In Windows, return to File > Options > Advanced and confirm that Automatically Flash Fill is clear under Editing options.
Confirm the application. You may have changed the preference in one Excel installation but be working in another, such as a separate work profile or desktop environment.
Distinguish suggestions from values. A preview or suggestion is not necessarily a completed fill. Pressing Enter or selecting a command may accept an action you did not intend.
Look for other causes. A formula copied down, AutoFill from a cell handle, a table calculated column, or pasted data can also populate cells. These are separate Excel features.

If an incorrect Flash Fill has already populated a range, undo it before doing more work if possible. Once other edits have been made, undoing may also reverse those later actions. If undo is no longer suitable, inspect the affected cells and restore the correct values from a reliable source or a saved copy. Because Flash Fill writes values, changing the preference afterward will not remove or repair the results already in the sheet.

Alternatives for repeatable or updating results

Choose a different method when you need results that update as source data changes, or when the transformation must be consistent and auditable. A formula can express a rule explicitly and recalculate when its referenced cell changes. For example, text functions can extract or combine pieces of data, although the right formula depends on the structure of the entries and the Excel version in use.

For recurring imports or multi-step cleanup, Power Query can provide a repeatable process: load the data, apply transformations, and refresh the query when new source data is available. This can be more reliable than manually repeating Flash Fill, but it takes some setup and is not necessary for a one-time, straightforward cleanup. For a short list with a simple, stable pattern, manual editing may be easiest.

Whichever method you choose, preserve the original data until you have checked the output. A practical workflow is to work in a new column, compare representative results, and only replace or remove the source after confirming that exceptions are handled. This is especially important for names, addresses, IDs, and imported records where a plausible-looking transformation may still be wrong.

Frequently Asked Questions

Does turning off Flash Fill disable Ctrl+E?

No. Clearing Automatically Flash Fill turns off the automatic behavior, not the manual command. In Windows desktop Excel, you can still use Ctrl+E or choose Data > Flash Fill when you want Excel to apply a pattern.

Why does Excel still fill a column after I turn it off?

You may have run Flash Fill manually, copied a formula, used AutoFill, or entered data in a table column that has its own calculated-column behavior. Check whether the cell contains a formula and confirm the automatic Flash Fill checkbox is clear in the Excel desktop app you are currently using.

Does Flash Fill update when the original data changes?

No. Flash Fill places values in the destination cells; it does not create a live link to the source. If you need outputs to update when source data changes, use a suitable formula or a refreshable data transformation instead.

Can I turn Flash Fill off for only one workbook?

The Automatically Flash Fill checkbox is an Excel application preference, not a per-workbook setting. You can leave automatic Flash Fill off and still run the command manually in a workbook where it is useful.

Is Flash Fill available in Excel for the web?

The desktop Flash Fill command and its automatic-fill setting are not available in the same way in Excel for the web. Open the workbook in a supported Excel desktop app to use those controls, or choose another method available in your environment.

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.