How to Disable Autocorrect in Google Sheets

Google Sheets is equipped with an aggressive autocorrect engine designed to catch spelling mistakes and automatically fix capitalization errors as you type. While this is incredibly helpful when writing an essay in Google Docs, it can become a massive headache when working with data in a spreadsheet. If you are entering unique product codes, scientific acronyms, or non-standard abbreviations, the autocorrect feature will constantly “fix” your accurate data, forcing you to go back and re-enter it. Fortunately, you can turn this feature off completely.

Why Autocorrect is Problematic for Data Entry

Spreadsheets are rarely used for standard prose. They are filled with alphanumeric strings and specific formatting that a generic dictionary cannot understand. For example, if you type an inventory code like tHe (perhaps standing for Tubular Heating Element), Google Sheets will instantly autocorrect it to The the moment you press Enter. If you are entering hundreds of these codes, the autocorrect engine turns from a helpful assistant into a destructive force that compromises the integrity of your data.

How to Turn Off Autocorrect Features

You can disable the autocorrect engine directly from the main toolbar.

1. Open your spreadsheet in Google Sheets.
2. Click on the Tools menu in the top navigation bar.
3. Hover your mouse over Spelling to open the sub-menu.
4. Click on Personal dictionary. (Wait, the setting is not there).

The Correct Path to the Settings

Let’s find the actual settings menu for autocorrect.

1. Click on the Tools menu in the top navigation bar.
2. Click on Preferences… (usually located near the bottom of the list).
3. A dialogue box will appear with two tabs at the top. Ensure you are on the General tab.
4. You will see a list of checkbox options. To stop the most common interference, uncheck the box next to Automatically capitalize words.
5. Next, uncheck the box next to Correct spelling automatically.

How to Manage the Substitutions List

Even with general autocorrect disabled, Google Sheets has a secondary feature that automatically swaps specific characters for others (for example, typing (c) and having it change to a copyright symbol ©). If this is causing issues with your data entry, you must disable it separately.

1. While still inside the Preferences dialogue box, click on the Substitutions tab at the top.
2. You will see a long list of automatic replacements.
3. To disable the feature entirely, uncheck the master box at the top labelled Automatic substitution.
4. Alternatively, if you want to keep the feature but remove a specific annoyance, scroll down the list, find the offending substitution, and click the small “X” next to it to delete it from the database.
5. Click the green OK button at the bottom right to save your changes.

Your spreadsheet will now accept exactly what you type, without any hidden alterations.