[Excel] How to turn off the noisy autocomplete in Excel

How to use Excel that I can't hear anymore

I want to turn off the display of noisy input candidates!

It is annoying that input candidates are displayed in the cell!

Excel has a lot of features to help you get the job done efficiently. But don't you feel that these useful features are a nuisance if they don't fit your way?

For example, Excel has a feature called autocomplete, which may display what has already been entered in the same column as input suggestions. If you enter "to" to enter "Shinagawa-ku, Tokyo ..." in the "Address" field (here, cell "E9") of the "List of Excel Introductory Students", "Tokyo" is entered in the same column. The text "XXXX-X, Wasedatsurumakicho, Shinjuku-ku" is displayed as an input candidate (①).

If you enter "to" to enter "Shinagawa-ku, Tokyo ..." in the "Address" field (here, cell "E9") of the "List of Excel Introductory Students", "Tokyo" is entered in the same column. The text "XXXX-X, Wasedatsurumaki-cho, Shinjuku-ku" is displayed as an input candidate (①

If it matches the content you are about to enter, it is convenient because it saves you time, but it can be annoying if it is displayed every time. Some people may have experienced that it was more troublesome to delete because the character string of the input candidate was automatically entered because the [Enter] key was inadvertently pressed even though it was not intended. Hmm.

So this time, I will explain how to quickly cancel the input candidate and how to turn off the autocomplete function of Excel.

You can delete input candidates by pressing the [Delete] key.

Using the same example as before, I will show you how to quickly delete the displayed input candidates. Input suggestions are displayed while you are typing in the cell, and if you want to delete them, press the [Delete] key. Let's actually do it.

In the same operation as before, if you enter "to" to enter "Shinagawa-ku, Tokyo ..." in cell "E9" of "List of students introductory to Excel", "Shinjuku-ku, Tokyo" is entered in the same column. The text "Waseda Tsurumakicho XXXX-X" is displayed as an input candidate (①).

In the same operation as before, if you enter "to" to enter "Shinagawa-ku, Tokyo ..." in cell "E9" of "List of students introductory to Excel", "Shinjuku-ku, Tokyo" is entered in the same column. The text "Waseda Tsurumakicho XXXX-X" is displayed as an input candidate (①).

Now, do not press the [Enter] key or the arrow keys in a hurry, but press the [Delete] key (②). Then, the input candidates are deleted.

At this point, do not press the [Enter] key or the arrow keys in a hurry, but press the [Delete] key (②).

However, if you continue to input, input candidates will appear again. In the next section, we will explain how to prevent this input candidate from being displayed at all.

Turn off the autocomplete function from the [Excel Options] screen

To prevent the contents already entered in the same column from being displayed as input candidates while entering characters in the cell, turn off the autocomplete function on the [Excel Options] screen. Let's actually do it.

Open one of the sheets and click the [File] tab (1).

Open one of the sheets and click the [File] tab (①).

From the menu on the left side of the screen, click [Others] (②) → [Options] (③).

Click [Others] (②) → [Options] (③) from the menu on the left side of the screen.

The [Excel Options] screen will be displayed. Click [Detailed Settings] (④) from the left column. Click [Use AutoComplete] in the [Edit Options] field (⑤) to turn off the check mark (⑥). After changing the settings, click [OK] (⑦) to close the [Excel Options Screen].

Click [Detailed Settings] (④) from the left column. Click [Use AutoComplete] in the [Edit Options] field (⑤) to turn off the check mark (⑥).After changing the settings, click [OK] (⑦) to close the [Excel Options Screen].

You will be returned to the sheet, so let's check if the settings have been changed. Even if you enter "to" in cell E9, the input candidates are no longer displayed as before (⑧).

Even if you enter "to" in cell "E9", the input candidates are no longer displayed as before (⑧).

Turn off unnecessary functions and make the settings easy to use.

This time, I explained how to turn off the autocomplete function of Excel.

This kind of input candidate display is convenient when it matches the content you are trying to input, but it can be annoying when it is displayed every time. If you don't need it, you may be able to work more smoothly if you turn it off. Please refer to it.