How to Spell Check Multiple Worksheets in Excel

By eHow Computers Editor

Rate: (0 Ratings)

Spell checking multiple worksheets in Excel is easy and more time efficient than going through each individual worksheet with a spell check. The process is simple, and it allows you to spell check even 50 worksheets at once in no time.

Flag Article

Instructions

Difficulty: Moderately Easy

Step1

Open Excel by double-clicking on the program's icon. Open the document with multiple worksheets that you want to spell check.

Step2

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.

Step3

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."

Step4

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."

Step5

Choose the option that fits your needs for each word. Clicking on that option takes you to the next error.

Step6

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."

Step7

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.