How to Spell Check In Excel

How to check spellings in Microsoft Excel:

Checking spellings in excel is very easy. Follow below steps to perform a spell check in Excel.

• With your excel spreadsheet opened, simply navigate to the ‘Review’ tab in the ribbon.
• In the ‘Review’ tab there is an option ‘Spelling’ as shown in the image.

• Clicking this option will initiate the spell checking.

Now there is one important thing that I would like to highlight. Before starting the spell checking if your cursor was on ‘A1’ cell then excel will start spell checking from that cell. If your cursor was on some ‘K10’ cell then spell checking will start from that particular cell. But in this case after reaching the end of the worksheet it will ask you “Do you want to continue checking at the beginning of sheet?”

If you click the ‘Yes’ button then it will check all the left cells, else if you select ‘No’ then it will leave the other cells as it is.

Shortcut Key for Spell-checking:

If you don’t like to use the spell-checking functionality using the button present on Excel ribbon then you can also do this by using a shortcut key. The shortcut key for this is ‘F7’.

While opening a spreadsheet if you press ‘F7’, then it will start the spell checking process.

Spell-check Multiple Sheets at Once:

While using the spell-check option you will realize that it can only check spellings on the active sheet. But by following the below method you will be able to check spellings on multiple sheets at once.

• Open the excel sheet, now right click on the name of your excel sheet.

• This will open a menu, select the option that says “Select All Sheets”. Now all the available sheets in your excel file will be selected.
• After this start the spell checking process by navigating to Review>Spellings, or by using the ‘F7’ key.

Highlight Misspelled words by using a Macro:

Finding misspelled words becomes quite easy by using the below macro. This macro changes the background color of the cells where misspelled words are present. This makes it easier for anyone to find the wrongly spelled words just by viewing the sheet.

To use this macro follow the below steps:

• Open the excel sheet for which you want to highlight the misspelled cells.
• Next, press “Alt+F11” keys, this will open Excel VBA editor.
• Navigate to Insert>Module.
• Paste following code inside the editor.

view plaincopy to clipboardprint?

1. Sub ColorMispelledCells()  
2. For Each cl In ActiveSheet.UsedRange  
3. If Not Application.CheckSpelling(Word:=cl.Text) Then _  
4. cl.Interior.ColorIndex = 28  
5. Next cl  
6. End Sub  

• After pasting the code press ‘F5’ key to run the macro.
• Next check your sheet, all the cells with misspelled words would have been highlighted in aqua color.

So, this was all about spell check in excel. If you come across any difficulty while using this option, please share it in the comments section.