How to Use Spell Check in Google Sheets to Find Misspelled Words

If you work with text in Google Sheets, there is an easy way to run spell check and take care of the misspelled words.

As an example, below I have the fruits name in Column A.

If you look closely, you can find two misspelled words in it – Aple (instead of Apple) and Strawbery (instead of Strawberry).

spell check in google sheets data

Now this is a small dataset, but if you have a lot of text, manually scanning for misspelled words would be time-consuming and prone to errors.

Here are the steps to run spell check in Google Sheets:

  • Select the data on which you want to run the spell check. If you want to run it for the entire sheet, click on the square at the top left of the sheet cells area.spell check in google sheets select entire sheet
  • Go to Tools –> Spelling.spell check in google sheets data spelling
  • This would run the Spell Check and if it finds any misspelled words, it opens the Spell Check dialog box as shown below.spell check in google sheets dialog box
  • In this Spell Check dialog box, you have the following options:
    • Change the highlighted instance of the misspelled word. If there are more than one occurrence of this word, you can check all the occurrences and correct it by selecting Change All.
    • Ignore the suggested change. If you have a name or item that is highlighted as misspelled, you can choose to ignore it. If there are multiple occurrences of it, you can choose to ignore all the instances by click on Ignore All.
    • If there is a word you want to add to the dictionary so that it isn’t highlighted as a misspelled word in future, click on Add to Dictionary.

Spell check continues to run as long as it finds misspelled words. If you want to close it, click on the cross at the top-right.

Related: Using Spell Check in Excel.

You May Also Like the Following Google Sheets Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.