Excel Perform A Spelling Check On The Active Worksheet

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.

Excel perform a spelling check on the active worksheet. Spell check is a commonly used utility in microsoft word to locate and fix words that have been misspelled. The keyboard shortcut to open the spelling dialogue box is f7. Right click on any sheet tab in the workbook you need to spell check then click select all sheets from the context menu.

Excel begins checking the spelling of text entries in the worksheet. Now all sheets in the current workbook are selected. If you select a single cell for spell check excel checks the entire worksheet including the comments page headers footers and graphics.

To perform the spelling check for multiple cells in your worksheet first select those cells where you want to perform the spell check. Now under the review tab select the spelling option. Then the spelling dialog box pops up in the protected worksheet as below screenshot shown.

How to spell check the current worksheet. When you run the spell check it starts from whichever cell is currently selected so if you want to start the spell check at the beginning of the worksheet put the cursor on cell a1 before starting. Click the spelling button on the review tab in the proofing group.

Perform a spelling check in multiple cells on the active worksheet. Use the spelling dialog box in excel 2007 to correct typos in a worksheet. With your excel spreadsheet opened simply navigate to the review tab in the ribbon.

To correct a mistake choose an appropriate opting under suggestions and click the change button. When the program comes across an unknown word it displays the spelling dialog box. Select the cell you need to enable the spell check in the protected worksheet then run the vba code by pressing the f5 key.