In this tutorial, you will learn how to spell check Google Sheets.
While text editing and spell checking might not be the first things you think about when thinking of Google Sheets, having professional and correctly spelled text to support your formulas and calculations is extremely important. Because of this, Google Sheets has a built-in spell checker that works much like a spell checker in a word processor. Read on to learn how to use it.
Using Google Sheets Spell Checker
You can spell check a single selection, an entire sheet, or all sheets in a Google Sheet. If you want to spell check only a portion of your spreadsheet select that range before following the below steps
Open the Tools menu and hover over Spelling, then choose Spell Check
In the upper-left of the Spell Check popup, the first misspelled word will display, with a text field below prefilled with the suggested correction
You can type in an alternate correction if you would like, or leave the default. Either way, if you click on Change to change the word to the suggestion, or Ignore to skip this instance of this word and move on
You can click the down arrow beside the Change and Ignore buttons to reveal the option to Change All or Ignore All. This will apply to all instances of the current misspelling
When there are no more spelling suggestions on the current sheet, a button will display allowing you to Search All Sheets for misspellings
If you selected a range before starting the spell checker, you will also be given the option to Search The Rest Of The Sheet
Adding Words to the Personal Dictionary
The Google Sheets spell checking dictionary is quite good, so most of the time you won’t have to add words to your personal dictionary. However, if you do use words that are not in the spell check dictionary, it can be frustrating to have to click Ignore for each of these words. And if you do misspell one of these words, the spell checker won’t help. For these cases, Google Sheets comes with a personal dictionary. Here’s how to use it:
While spell checking your spreadsheet, if you come across a word that is spelled correctly but that the spell checker doesn’t recognize, instead of changing or ignoring the word, you can click the Add to Dictionary button
The word will then be added to your personal dictionary, and whenever you use the Google Sheets spell checker under the same account, this word will be treated as if spelled correctly
You can also directly add new words to your dictionary (or delete existing ones) by opening the Tools menu and choosing Personal Dictionary from the Spelling submenu
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to spell check Google Sheets. Want more? Check out all the Google Sheets Tutorials.