Spell Check In Excel Column
Select the sheet tabs you wish to check.
Spell check in excel column. For this press and hold the ctrl key while clicking the tabs. By default excel only looks at a single sheet when checking spelling. Excel will check spelling mistakes in all the selected worksheets.
Learn how to check the spelling of text in excel. Before pressing f7 or the spelling button right click on any sheet tab and click select all sheets. Follow the below steps to perform a spell check in excel.
On the review tab in the proofing group click spelling. In the review tab there is an option spelling as shown in the image. Select a suggestion and click change to correct the misspelling in cell a2.
Then run spell check as normal. Open a worksheet with some spelling errors. With your excel spreadsheet opened simply navigate to the review tab in the ribbon.
Press the spell check shortcut f7 or click the spelling button on the review tab. You can tell it to spell check multiple sheets at once with a simple trick.