Auto Spell Check In Excel 2016 Not Working
The steps are detailed in the post but i ll re post them here.
Auto spell check in excel 2016 not working. Notice in the above image that the currently selected worksheet tab displays in white and the inactive tab displays in gray. Of course there are a few tweaks you can make to how excel checks your spelling. If the spelling checker comes back with one and only one suggested correct spelling the word you typed is replaced with the one offered by the spell checker.
Clear the check box of any item for which you don t want auto formatting done. While opening a spreadsheet if you press f7 then it will start the spell checking process. Excel might not automatically check your spelling but it makes the process very easy.
By default excel does some auto formatting while you re typing such as applying bullet or numbered list formatting when it detects that you are typing a list. Spell check multiple sheets at once. Click file options proofing autocorrect options.
Use this dialog box if you want to turn off any of these auto formatting options. That s all you need to know. Check spelling using vba macros you might want to enable or disable spell checking auto corrects in your word and excel vba macros.
That s the reason that excel can t spell check as you type your text. Just hit f7 or the spelling button in the review tab. In access or infopath you can skip this step.
In project you ll go to the project tab. After trying a few common troubleshooting techniques i did some online research and found this microsoft user forum post which gave me the solution. 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.