How to use the Spell Check function in WPS Spreadsheet

Uploaded time: January 17, 2022 Difficulty: Beginner

How to use the Spell Check function in WPS Spreadsheet

How to use the Spell Check function in WPS Spreadsheet

Tips: you can turn on the volume by clicking

The Spell Check function of WPS Spreadsheet can help us quickly trap misspelled words and provide suggestions for correction, greatly saving the calibration time of the table.

In the Review tab, click the Spell Check button and open the Spell Check dialog box, whose shortcut key is F7.

In the text box on the left, we can see some words marked in red. These are the words in which WPS Office has detected possible spelling mistakes. _1.gif


Take this table as an example. The cells are checked from left to right and then from top to bottom.

Select cell A1 and click on the Spell Check button to check the entire table. In the Suggestions section of the right pane, the system will intelligently generate new words according to the spelling of the original words.

Select the desired word and click Change to correct it. _2.gif


Also, we can apply the Spell Check function in specified areas.

If we want to correct the misspelled words in column C, select the column and press the shortcut F7 to open the Spell Check dialog. Then we can see the word Doctor is misspelled. Select it and click Change All to correct the same misspelled words in the selected area. _3.gif


We can also see the names in the file are marked in red, but the words are correctly spelled.

In this case, we can choose to ignore or delete the prompt.

· Ignore

Take the word Urbano as an example, click Ignore in the pane, and we can ignore the error message of the word.

And click Ignore All to ignore all error messages for this word in the table this time.

· Add to Dictionary

If we want to dismiss error messages of one word in subsequent checks, we can add the word to the proofread dictionary.

Take Sixto as an example. Click Add to Dictionary in the right pane.

Thus, no error marks of this word will appear in subsequent checks. _4.gif


In the Spell Check drop-down button, we can select Set Language to set three different languages simultaneously at most, according to the languages of the file. _5.gif


Keywords: Excel, Spreadsheet, WPS Spreadsheet, et, spelling mistake, spell check, error mark, correction, correct error, ignore the error