Many a times, people spell or type words according to their pronunciation or according to how they believe it is spelt. It is paramount to double check your spreadsheet for spelling errors especially when it is to be presented to an audience. In this post, we would take you through how to check spellings of text in excel, and how to add words to your custom dictionary. Let’s begin.
Changing Misspellings
Step 1: Open your worksheet containing some text to begin
Step 2: Go to the review tab and click spelling or F7
Step 3: Select a suggestion and click on change to correct the misspelling in A1
Step 4: Move on to the next cell and repeat the process. Click on change all to correct all instances of this misspelling in the data set (A2:A12).
Result: The word has been corrected in the two instances it appeared in: Cells A2 and A12
Defining Auto Correct Words
You might be prone to misspelling some particular types of word and you may just want excel to have your back whenever this happens. This is where the auto correct feature comes to play. To add words to your auto correct list, simply follow the steps below:
Step 1: Select the word giving you this issue of constant misspellings and navigate to spelling under the review tab (or click F7).
Step 2: Select the correct suggestion and click on auto correct
To edit the auto correct list, click options > proofing and then click auto click options
In the Auto correct pop out box, you can add new words and their default auto correct word to the list.
You can customize this list to include abbreviations or any type of word. Just type in the word you seek to auto correct in the “replace:” box and then the correct word in “With:”.
Click on Add and then OK and you’re done.
Result:
