The Predictive Typist
Microsoft Excel includes an aggressive predictive text feature called “Flash Fill.” If you have a column of full names (e.g., “John Smith”) and you start typing the first names (“John”) in the column next to it, Excel will suddenly gray out the rest of the column and suggest automatically splitting all the names for you. While Flash Fill is a brilliant tool for data extraction, the automatic suggestion overlay can be incredibly visually distracting when you are simply typing similar data and do not want Excel to intervene.
How to Disable Automatic Flash Fill
You can turn off the automatic “pop-up” aspect of Flash Fill without completely losing the feature. You will still be able to use it manually; Excel just won’t throw gray predictive text at you while you type.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. Look at the very bottom of the green sidebar on the left and click Options. (If you don’t see it, click “More…” first).
4. In the Excel Options window, click on Advanced in the left-hand menu.
5. Look at the very first section at the top, labelled “Editing options.”
6. Locate the checkbox labelled Automatically Flash Fill.
7. Uncheck this box.
8. Click OK at the bottom of the window to save your changes.
How to Use Flash Fill Manually
Now that the annoying automatic suggestions are disabled, you can still use the power of Flash Fill when you actually need it.
1. Type the data you want to extract into the first cell (e.g., type “John” next to “John Smith”) and press Enter.
2. Click on the cell immediately below the one you just typed in.
3. Go to the Data tab on the ribbon.
4. In the “Data Tools” group, click the Flash Fill button (it has an icon of a small lightning bolt).
5. Alternatively, use the keyboard shortcut: press Ctrl + E.
Excel will instantly analyze the pattern from the first cell and execute the Flash Fill command on the entire column, giving you total control over when the feature activates.