How To Get Auto Spell Check In Excel

In the ribbon open the review tab.

How to get auto spell check in excel. By default excel only looks at a single sheet when checking spelling. Spell check in excel is a method of proofing which means we can check the spelling of the words or texts in the cell either by manually or we can enable auto spell check in excel to check spell manually press f7 on the cell and it will open dictionary for us and it will suggest the words which are closely possible or we can go to options and select proofing to enable auto to spell check. Then run spell check as normal.

Open most office programs click the review tab on the ribbon. Before pressing f7 or the spelling button right click on any sheet tab and click select all sheets. Notice in the above image that the currently selected worksheet tab displays in white and the inactive tab displays in gray.

Follow the below steps to perform a spell check in excel. First things first the excel spell checker is located in the review tab. To change the spelling checker options follow these steps.

To spell check all the worksheets in a workbook right click on the current worksheet tab at the bottom of the excel window and select select all sheets from the popup menu. In the review tab there is an option spelling as shown in the image. Check spelling and correct automatically with autocorrect options if you want to automatically correct the wrong spelling you can specify the autocorrect options.

Open your workbook and navigate to your worksheet. If you select multiple cells excel checks spelling only for those cells. Click file options proofing autocorrect options.

You can tell it to spell check multiple sheets at once with a simple trick. In excel 2010 or a later version display the file tab of the ribbon and then click options. Clicking this option will initiate the spell checking.