How to Prevent Auto-Corrections in Google Sheets

Google Sheets is built for data, so it tries to be helpful as you type: it suggests entries from the same column, offers fixes for formulas, and converts things that look like dates or numbers into its own formats. Sometimes that “help” changes what you actually meant to enter, like turning a product code into a date or completing a name you didn’t want. Below is each type of automatic change in Google Sheets and how to stop it.

1. Turn Off Autocomplete

Autocomplete suggests text based on entries already in the same column. If you type “Jo” and the column already contains “Jones,” Sheets fills in the rest, and pressing Enter accepts it.

  1. Click Tools in the menu bar.
  2. Find Autocomplete (in some versions it’s a submenu) and uncheck Enable autocomplete.

To skip a single suggestion without turning the feature off, press Delete or Backspace to remove the suggested text before pressing Enter.

2. Turn Off Formula Suggestions and Corrections

When you type a formula, Sheets may suggest functions or offer to fix a formula it thinks is wrong. If these prompts get in the way, look in the same Tools menu (or its Autocomplete submenu) and uncheck options such as Enable formula suggestions and Enable formula corrections. Menu names can vary slightly as Google updates Sheets.

Do these settings apply to all my spreadsheets?

Autocomplete and formula settings in the Tools menu are generally saved to your account, while number formats like Plain text apply only to the cells you format.

3. Stop Sheets from Converting Numbers and Dates

This is the most common “autocorrect” complaint. Sheets automatically interprets entries like 1/2 as a date, removes leading zeros from ZIP codes and IDs, and turns long numbers into scientific notation.

Format cells as plain text

  1. Select the cells or column before typing.
  2. Go to Format > Number > Plain text.
  3. Type your data. Sheets keeps it exactly as entered.

Use an apostrophe for a single entry

Type an apostrophe before the value, such as ‘00123 or ‘1/2. The apostrophe doesn’t appear in the cell, and Sheets treats the entry as text.

Fix entries that were already changed

If a value has already been converted, changing the format afterward may not restore the original (for example, removed leading zeros are gone). Reformat the cells as Plain text, then re-enter the values.

How do I reset cells that have the wrong format?

Select them and use Format > Clear formatting, then apply the format you want. See how to clear formatting from a cell in Google Sheets.

If you do want real dates, see how to insert a date in Google Sheets.

4. Turn Off Spell Check Underlines

Google Sheets doesn’t automatically rewrite misspelled words, but it can show spelling suggestions. To check spelling only when you want to, use Tools > Spelling and run the spell check manually, and turn off any automatic spelling option shown in that submenu.

5. Check Your Device’s Autocorrect

If words are being replaced as you type, the change may be coming from your device rather than Sheets:

  • Mac: macOS can correct spelling in browsers. Go to System Settings > Keyboard > Text Input > Edit and turn off Correct spelling automatically. Also check Text Replacements for unwanted entries.
  • iPhone or iPad: Go to Settings > General > Keyboard and turn off Auto-Correction.
  • Android: In your keyboard’s settings (for example, Gboard > Text correction), turn off Auto-correction.
  • Browser extensions: Grammar and writing extensions can also change text. Try disabling them to see if the problem stops.

6. Stop Automatic Links

Sheets turns web addresses and email addresses into clickable links. To keep one as plain text, type an apostrophe before it, or remove the link afterward by right-clicking the cell and choosing the option to remove the link.

More ways to keep entries as typed

  • Set an entire column to Plain text before pasting in IDs, phone numbers, or product codes.
  • Use Data > Data validation with a dropdown list if you want consistent entries without relying on autocomplete.
  • Press Ctrl + Z (Command + Z on Mac) right after an unwanted change to undo it.