How to Spell Check in Excel

Learn how to spell check in Excel so that you don’t send out any Excel worksheet with misspelled words or phrases. The tutorial shows you multiple spell-checking methods in Microsoft Excel, like using the Spelling command, a keyboard shortcut, and Excel Macro (VBA code.)

How to Spell Check in Excel Using the Spelling Tool

If you’ve got an Excel workbook with a few texts and you need to spell check the content, follow these steps:

1. Open your Excel workbook.
2. Select the range of cells for which you want to perform spell check.
3. If you need to check spelling in multiple worksheets, press Ctrl and then select those worksheets.
4. Now, click on the Review tab in the Excel ribbon menu.

1. You’ll see the Spelling command in the Review tab. Click on that to open the spell checker tool.
2. The tool will automatically highlight the first misspelled word of the selected cell range.
3. Click on Change to correct the misspelled words one by one.

Remember that you need to select a cell range for spelling correction. Otherwise, Excel will start scanning the entire worksheet if you select any random cell.   

How to Spell Check in Excel Using a Shortcut Key

Here’s a shortcut in case you frequently need to perform spell checking:

1. The shortcut key for the spell checker tool of Excel is F7.
2. Select the cells or worksheets and then simply hit the F7 key. It should be in the function key section of your QWERTY keyboard.

1. The spell-checking tool will appear.
2. Click Change to correct one word or Change All for all words.  

How to Spell Check in Excel Using Excel Macro

If you’re an Excel pro and you want to automate the spell checking task, you should try this Excel Macro:

1. Press Alt+F11 to open the Excel VBA (Visual Basic for Applications) editor.
2. Right-click on VBAProject(Excel File Name.xlsx).
3. Hover the mouse cursor over Insert and then select Module from the menu that appears.
4. Module1 (Code) frame will open. This is the VBA editor where you need to copy-paste the below-mentioned VBA code for spell checking.

Sub SpellCheckActiveSheet()

       Application.ScreenUpdating = False

       Application.Calculation = xlCalculationManual

       ActiveSheet.CheckSpelling

       Application.ScreenUpdating = True

       Application.Calculation = xlCalculationAutomatic

End Sub

Now, follow these steps to save and execute the VBA code:

1. In the VBA editor, press Ctrl+S.
2. Select No in the notification box that appears.
3. Now, Excel will prompt you to save the previous Excel file again.
4. You’ll see the Save as type drop-down menu in the Save As window.
5. Click on the menu and select Excel Macro-Enabled Workbook from that drop-down list.
6. Now, click on Save to save your existing Excel file with the VBA code.
7. Press Alt+Q to close the VBA editor.
8. Close the existing Excel file and open the new one with Macro.
9. Click on the Enable Content button to activate Macro on your Excel workbook.
10. Press Alt+F8 to open the Macro menu and select SpellCheckActiveSheet.

1. Now click on Run to open the Spelling tool.
2. Click on Change All to correct all the misspelled words.

Conclusion

Since Microsoft Excel is supposed to process numbers and mathematical formulas, that doesn’t mean it shouldn’t have a spell-checking tool. It does have a basic tool that helps you correct spelling issues. 

You can utilize any of the aforementioned steps to get rid of spelling errors from your Excel workbook and showcase your credibility to your clients or co-workers.

Read Full Bio

Tamal Das

Tamal is a freelance writer at AddictiveTips. After gaining substantial experience in technology, finance, and business processes in his previous job in an IT consulting company, he adopted writing as a full-time profession 3 years ago. While not writing about the latest technology, he loves to play COD and binge-watch

Latest from Author

How to Screenshot on Windows 7 Without Snipping Tool How to Type an Em Dash: Top 5 Methods