How to Turn Off Autocomplete in Google Sheets


Autocomplete is a helpful setting in a number of different programs where you might be repeatedly entering the same word. Autocomplete works by recognizing the first few letters that you have typed, seeing that a similar word already exists in the document, then offering that word to you in the form of a blue-highlighted suggestion. If you press Enter on your keyboard when the autocompletion is presented, Sheets will add that word to the cell without requiring you to type the rest of it.

While this is helpful sometimes, you may find that it is causing you problems. Fortunately autocomplete can be disabled in Google sheets by completing the steps below.

 

How to Stop Autocomplete in Google Sheets

The steps in this article are going to prevent Google Sheets from giving you an autocomplete option when you are typing data. By this we mean the text highlighted in blue that occurs when you start typing a word that is already in the sheet. For example, in the image below, Sheets is giving me an autocomplete option for the word September when I type the first few letters of the word.

autocomplete turned on example

 

Turning off the autocomplete option will prevent that from occurring.

 

Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and double-click the spreadsheet for which you would like to disable autocomplete.

 

Step 2: Click the Tools tab at the top of the window.

open the tools menu

 

 

Step 3: Click the Enable autocomplete option to remove the check mark.

turn off autocomplete in google sheets

 

 

Now when you start typing a word that already exists in Google Sheets it won’t give you the option to press Enter on your keyboard and add that word. Autocomplete has been disabled in the picture below.

autocomplete turned off example

 

Do you need to simultaneously change the width of multiple columns in Google Sheets, but you’re having trouble getting it to work? This guide will show you how to make it happen.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.