Yes. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced, clear Automatically Flash Fill under Editing options, and select OK. This turns off automatic suggestions; you can still run Flash Fill yourself from Data > Flash Fill or with Ctrl+E.
What the Flash Fill setting controls
Flash Fill recognizes a pattern in data you enter and uses it to complete nearby cells. For example, if column A contains full names and you type a first name beside the first record, Excel may identify the pattern and show a preview for the remaining rows. It can also help split text, combine pieces of information, or change how values are presented.
The checkbox named Automatically Flash Fill controls whether Excel offers or applies that pattern-based fill automatically as you work. It is an Excel application setting, not a switch saved separately in each worksheet. Turning it off is useful if the suggestions interrupt your typing or if you prefer to control when Excel fills data.
Flash Fill is different from AutoFill, which extends a sequence or copies a cell’s contents and formatting using the fill handle. It is also different from a formula: Flash Fill writes results into cells as values rather than leaving a formula that recalculates from the source data. That distinction matters if the original names or text may change later.
Turn off automatic Flash Fill on Windows
- Open Excel and select File.
- Select Options to open the Excel Options window.
- Select Advanced in the left-hand list.
- Under Editing options, clear Automatically Flash Fill.
- Select OK to save the change.
The setting may be farther down the Advanced page than the options visible when the window first opens, so scroll through the Editing options if you do not see it immediately. The change affects Excel’s behavior after you confirm it; it does not undo or remove values Flash Fill has already placed in a worksheet.
To restore automatic suggestions later, follow the same path and select the checkbox again. You do not need to change a workbook’s formulas or rebuild a sheet to switch the behavior on or off.
Turn off automatic Flash Fill on Mac
In Excel for Mac, open the Excel menu in the macOS menu bar, choose Preferences or Settings depending on the version, and open Edit. Clear Automatically Flash Fill, then close the settings window. The wording and layout can vary slightly between Mac releases, but look in Excel’s editing preferences rather than in the worksheet itself.
If you use Excel for the web, its menus and available features differ from the desktop application, and the desktop preference path above does not apply. Open the workbook in the Excel desktop app when you need to change this specific setting. The Windows instructions apply to Excel for Microsoft 365 on Windows; they are not instructions for Google Sheets or other spreadsheet programs.
Automatic suggestions versus manual Flash Fill
Disabling automatic Flash Fill does not generally remove the manual command. You can still enter a few examples that show the pattern you want, select the cells where the remaining results should go, and choose Data > Flash Fill. On Windows, Ctrl+E is the keyboard shortcut for Flash Fill. If you are on a Mac and are unsure which shortcut your Excel version uses, use the Data tab command instead.
For instance, imagine A2 contains Jordan Lee and A3 contains Priya Shah. If you want first names in column B, type Jordan in B2 and Priya in B3, then select the destination cells below the examples and run Flash Fill. Excel may infer that the text before the space is the desired result. Check the filled entries rather than assuming the pattern is correct, especially when names include middle names, compound surnames, or inconsistent spacing.
Manual use is a good compromise when you find automatic suggestions distracting but still want the tool for occasional cleanup. You decide when to invoke it, and the source data remains separate if you choose a new output column.
What changes when you turn it off
With automatic Flash Fill disabled, Excel should stop reacting to a recognized pattern by offering or completing a Flash Fill result automatically. It does not disable ordinary typing, formulas, AutoFill, or the Data tab command. It also does not clear existing results, convert them back to their source text, or prevent you from editing those cells.
Because Flash Fill creates values rather than a live relationship with the source, later changes to the original data do not automatically update the filled results. For example, if you used it to extract first names and then corrected a full name in column A, the corresponding first name already produced in column B may need to be corrected separately. Turning off the feature does not change this behavior in existing cells.
If Excel has already filled a range and the results are wrong, inspect the affected cells before continuing. You can use Ctrl+Z on Windows immediately after the action to undo it, or edit or clear the results directly. Undo is not a substitute for checking the workbook: later actions can change what Ctrl+Z reverses.
Why Flash Fill may still appear or fail
- The setting was not changed: Reopen File > Options > Advanced and check the Automatically Flash Fill box. Make sure you selected OK after clearing it.
- You ran the manual command: Choosing Data > Flash Fill or pressing Ctrl+E deliberately requests a fill, even when automatic suggestions are off.
- The result is already in the cells: Disabling the setting prevents future automatic behavior; it does not erase prior output. Clear or correct those cells if needed.
- Excel does not recognize the pattern: Provide more examples, make the examples consistent, or use a formula or another transformation method. Flash Fill is pattern recognition, not a guarantee that Excel understands the meaning of every entry.
- The source data is inconsistent: Extra spaces, different punctuation, middle names, or varying formats can make a simple example ambiguous. Review the output row by row before using it for important records.
A common misconception is that turning off Flash Fill switches off every kind of automatic filling in Excel. It does not. AutoFill, formulas, and other data-entry tools have separate behavior. If a series continues when you drag a cell’s fill handle, that is not evidence that Flash Fill is still enabled.
When to use a formula or another approach
Flash Fill is convenient for a one-time transformation when the examples are clear and you are comfortable checking the results. A formula is often better when the output must stay linked to source cells. For a straightforward first-name extraction from consistently formatted full names, for example, a formula can calculate a result from each source row; if the source is edited, the formula can update when recalculated. The right formula depends on the data structure, particularly whether names contain middle names or multiple spaces.
For repeatable work, Power Query may be a better fit. It can apply recorded transformation steps to a dataset and repeat them when you refresh the query. That is different from Flash Fill, which is usually a quick worksheet action that writes results into cells. A formula, Power Query, or a manual edit may be safer when the transformation has exceptions that cannot be captured by a short example pattern.
- Choose manual Flash Fill for a quick, occasional transformation you can review.
- Choose a formula when results should respond to changes in source cells.
- Choose Power Query when you repeat structured cleanup on imported data.
- Choose manual editing when each entry needs judgment or the pattern has many exceptions.
Whichever method you use, keep the original data until you have checked the result. A separate output column makes comparisons easier and reduces the risk of overwriting information you may need.
Frequently Asked Questions
Can I turn off Flash Fill for just one worksheet?
There is not a separate worksheet-level Automatically Flash Fill checkbox in the Windows Options path. The setting controls Excel’s automatic behavior more broadly. For a one-off task, turn automatic Flash Fill off and use the Data tab command only when you want it.
Does turning off Flash Fill disable Ctrl+E?
No. The setting controls automatic suggestions, while Ctrl+E on Windows is a command to run Flash Fill manually. The Data tab command is another way to invoke it.
Will turning it off delete results already in my workbook?
No. Existing filled values remain in their cells. If they are incorrect, undo the recent action if possible, or select and edit or clear the affected cells.
Why does Flash Fill give me the wrong names?
It may infer a pattern that does not account for exceptions such as middle names or compound surnames. Add representative examples, inspect all results, and use a formula or manual correction when the data is inconsistent.
Is Flash Fill the same as AutoFill?
No. Flash Fill detects a text pattern, such as extracting part of a name. AutoFill extends or copies cell contents and sequences, often using the fill handle. Turning off automatic Flash Fill does not turn off AutoFill.
Choosing the setting that suits your workflow
Turn off Automatically Flash Fill when you want Excel to stop making pattern-based suggestions as you type. Keep manual Flash Fill available for tasks where it saves time, and review its output before relying on it. If the transformation must stay connected to its source or handle complicated exceptions, use a formula, Power Query, or careful editing instead.
Related
- How to Hyperlink in Excel on a Mac: Web, Files, and Cells
- Detect Circular References in Excel: Step-by-Step
- How to Get Around a Circular Reference in Excel Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Work Out Percentages in Google Sheets EasilyTo work out a percentage in Google Sheets, divide the part by the total, then format the result…
- Conditional Formatting Text in Excel: Rules and ExamplesTo conditionally format text in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Google Sheets: Count Unique Values in a Column EasilyTo count distinct values in a Google Sheets column, use =COUNTUNIQUE(A2:A) when the data starts in A2. To…
- Can You Put Text With a Checkbox in Google Sheets?Yes—but a Google Sheets checkbox does not display ordinary text inside its box. Put the label in a…
- Excel Workbook Performance: How to Diagnose SlownessExcel workbook performance depends on how much data and formatting a file contains, how its formulas are structured,…
- Excel Table Reference Syntax: A Practical GuideExcel table references use a table name and, usually, a column name in square brackets. For example, with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.