Friday, July 26, 2013

How to Spell Check Multiple Worksheets in Excel


1. Open Excel by double-clicking on the program's icon. Open the document with multiple worksheets that you want to spell check.
2. Click on the first bottom tab while holding down the 'Shift' key. Continue holding down the 'Shift' key and click on the remaining tabs to highlight all worksheets that need checking for spelling or grammatical errors.
3. Select the 'Tools' menu option and then choose 'Spelling.' A popup box appears asking, 'Do you want to continue checking at the beginning of the sheet?' Click 'Yes.'
4. Review each word that the computer doesn't recognize. The spell check takes you through each worksheet. The popup box gives you options for each spelling mistake: 'Ignore,' 'Change,' 'Add,' 'AutoCorrect,' 'Ignore All' or 'Change All.'
5. Choose the option that fits your needs for each word. Clicking on that option takes you to the next error.
6. Go through each potential error that pops up. A popup box then appears stating, 'The spelling check is complete for the selected sheets.' Click on 'OK.'
7. Hit 'Save' to save any changes you made to your worksheets. Then, click on one of the tabs highlighted so further changes you make don't affect multiple worksheets.

Blogger news