How to use Spell Check in Excel

December 10, 2021
3.1K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

· Change

1. Click the Review tab and the Spell Check drop-down button, choose Spell Check.

2. If there are errors in the content of our document, the Spell Checkwindow will pop up. Then, we will see the misspelled words.

3. Select the correct word in the Suggestions area, and click the Change button. In this way, we can correct this word.

4. Or we can click theChange Allbutton to correct the misspelling of all these words in Excel.

1.gif

· Ignore

1. Click the Ignore Once button, then we can ignore this wrong word.

2. Or click the Ignore All button, then we can ignore all spelling mistakes of this word.

2.gif

· Delete

1. Click the Delete button, then we can quickly delete this misspelled word in the table.

3.gif

· Add to Dictionary

If the spelled word is not in the dictionary, we can click the Add to Dictionary button. Then, we can add the corresponding word to the dictionary. In this way, If we encounter this word again, we will not get an error message.

4.gif

· Set Language

1. Go to the Review tab, click the Spell Check drop-down button, and choose Set Language.

2. In the pop-up Set Spell Check Language dialog, we can choose other languages being proofread according to the language in Excel.

5.gif

· Custom Dictionary

1. Click the Menu drop-down list, and click Options.

2. In the pop-up dialog, click Spell Check.

3. We can check options such as Always suggest corrections, Ignore words in uppercase, Ignore words with numbers in the Spell Check area.

4. In the Custom Dictionary area, we can set the dictionary to check words in Excel.

6.gif

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.