How to Spell Check a Worksheet in Microsoft Excel 2010


Spell check is a commonly used utility in Microsoft Word to locate and fix words that have been misspelled. But Word documents are not the only place where incorrectly spelled words can exist, so you may find that you need to check the spelling in an Excel 2010 spreadsheet.

Fortunately Excel 2010 also has a spell checking utility, and it is very similar to the one found in Word 2010. Our guide will show you how to access and use it to fix any typos that might exist in your spreadsheet.

 

Check Spelling in an Excel 2010 Spreadsheet

This tutorial was written specifically for Microsoft Excel 2010. However, these steps are very similar for other versions of Excel as well.

 

Step 1: Open your spreadsheet in Microsoft Excel 2010.

 

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

click the review tab

 

 

Step 3: Click the Spelling button at the left side of the navigational ribbon, in the Proofing section.

click the spelling button

 

 

Step 4: If you get a pop-up window asking “Do you want to continue checking at the beginning of the sheet,” click the Yes button.

click the yes button

 

 

Step 5: Select how you want Excel to handle each misspelled word that it encounters. The misspelling is in the Not in Dictionary field at the top of the window. Possible correct spellings are in the Suggestions field at the bottom of the window. You will need to manually select one of the options in the Suggestions field to use either of the Change options at the right side of the window. The available actions in the spell checker are:

Ignore Once – Excel will ignore this single instance of the word and leave it in the spreadsheet with the misspelling.

Ignore All – Excel will ignore all instances of this misspelled word and leave them in the spreadsheet as they are.

Add to Dictionary – Add this word to the Excel dictionary so that Excel no longer flags it as a misspelled word.

Change – Change the misspelled word to the word that is currently selected in the Suggestions field.

Change All – Change all instances of this misspelled word to the option that is currently selected in the Suggestions field.

AutoCorrect – Excel will automatically choose a correct spelling for the word in the Not in the Dictionary field.

Options – Make adjustments to the way that the spell checker runs in Excel.

choose what to do with the misspelled word

 

 

Step 6: Click the OK button on the pop-up window that says The spelling check is complete for the entire sheet to close the spell checker.

click the ok button

 

 

Is there a lot of strange formatting in your spreadsheet, and you would like to remove it all? This guide will show you how to clear all of the formatting from an Excel 2010 spreadsheet.

solveyourtech.com newsletter
vintage t rex t-shirt

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