Challenge with spell check with multiple worksheets
 

If I have multiple worksheets selected and run spell check, correcting a
misspelling sometimes affects all of the same cells on each worksheet (e.g.,
all C6 cells in the selected worksheets change to the corrected word). This
does not always happen. Sometimes the "other" cells in selected worksheets
don't change (meaning that only the cell with the misspelling changes). This
leads me to believe that there is some magical button or function that I can
use to turn this option off and on. Please, oh please, tell me this is true
and point me in the right direction.