WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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

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 Wp data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/a746d55b64f08adce10f173b0c086260_0.46_6917.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

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  data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/a1d566e443c241e29b04bc0d989383f0_0.46_2250.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

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  data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/9d3728dabe5981b5cc549b96fcbbf09f_0.46_4687.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

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 ap data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/76d28ca0c88647763c441e4a48600232_0.46_1512.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

In the Spell Check drop-down button, we can select Set Language to set three different  data-imgw=720 data-imgh=405 data-src="//res-academy.cache.wpscdn.com/images/3f4ec2122439e2b5931653c7dfd3cdbb_0.46_4907.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(405/720)); text-align:center;" >

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

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.