Spell Check In Excel 2013 Not Working
B ecause spellchecker is not smart enough to know which cells are protected when protection is on spelling is off.
Spell check in excel 2013 not working. If you select multiple cells excel checks spelling only for those cells. Sub selectunlockedcells spellcheck activesheet unprotect password your pass word between these quotes dim. Hi as far as i know excel does not spell check protected worksheets formulas or text that results from a formula.
Excel doesn t check spelling in cells that contain formulas so to spell check words in a formula bar select the words. All the 2013 users when they try to open an excel file and intentionally type a misspelled word the autocorrect still says its correct. A screenshot sample of words that excel doesn t recognize as incorrectly spelled would also be appreciated so that we could study it further.
We can use a macro as a workaround sample code.