Hi! I am trying to clean up a large spreadsheet (~500,000 rows) with a lot of spelling errors. The problem I'm having is that choosing "Change All" only applies the change to "all" if you complete the spell check. Due to the large number of errors it is not possible for me to fix all the errors in one sitting, therefore I have to close the spell check window prior to finishing which means the "Change All" is not applied to anything past where I stopped. I would love to figure out a way to have any "Change All" applied to the whole spreadsheet immediately so I don't have to address the same correction in multiple sessions.

Thanks in advance!

Example: If I run spell check on this list, the checker will stop on #4 and suggest "words", if I click "Change All" #4 will be corrected and the checker will move to #9 to suggest a correction. If I close out the checker at this point, #12 will still be misspelled despite earlier choosing "Change All" for the same error.



1 word
2 test
3 another word
4 wrds
5 again
6 cake
7 pizza
8 mistake
9 prblem
10 correct
11 right
12 wrds
13 spatula