Check spelling

To enable and disable Check Spelling, on the Tools menu, select Spelling and Grammar and then Check Spelling.

Enabling or disabling Check Spelling is only applied to the current document and does not affect other opened documents.

Check spelling basics:

•The spell-checking dictionary is automatically selected based on the language of the first character in the cell.

•Words missing in the selected dictionary or misspelled words are underlined with a red wavy line.

• Changing the contents of a document restarts spell-checking.

Find spelling mistakes

To quickly find words with spelling errors, use the following key combination Alt+F7. When clicking the Alt+F7 combination for the first time, the cell that contains the first found word with the spelling mistake is highlighted on the current sheet. Each subsequent click highlights the cell that contains the next word with the spelling error.

The search for errors is performed on all sheets of the document, from the current to the last sheet. Once the end of the document is reached, the search for words with errors is performed from the first sheet.

Correcting spelling errors

To correct a misspelled word:

1.Move the pointer over the misspelled word underlined with a red wavy line or select it.

2.Right-click the word directly in the cell or in the Formula bar.

3.On the context menu, select the correct spelling.

If no correct spelling can be suggested for the word, you'll see the No suggestions notification in the context menu.

Turn off the underline for spelling errors

A word recognized as misspelled by the application is underlined with a red wavy line. To turn this option off for a particular word, add it in the Custom dictionary or to the ignore list.

To add a word in the ignore list, follow the steps below:

1. Move the pointer over the misspelled word underlined with a red wavy line or select it.

2. Right-click the word directly in the cell or in the Formula bar.

3. On the context menu, select Ignore.

Once finished, the red wavy underline disappears. If a word appears several times in the document, the changes are applied to all repetitions taking into account the case. Such changes are saved within one session. When the document is opened again, the Check Spelling is launched again.

If you've added a word to the ignore list by mistake, you can get back to the previous step by selecting the Check Spelling option. Simply follow the steps below:

1. Move the pointer over the word or select the word.

2. Right-click the word directly in the cell or in the Formula bar.

3. On the context menu, select Check Spelling.

To exclude words such as proper names, abbreviations or technical terms in a text from being considered misspelled, you can add them to the Custom dictionary.

Before you start, make sure that the Check Spelling is on.

Add a word to the dictionary

The Custom dictionary allows you to add individual words but not word combinations.

Adding words is case-sensitive. If a word can begin with a capital letter and with a lowercase letter, add the two spellings into the dictionary.

To add a word to the Custom dictionary directly from the text, follow the steps below:

1. Move the pointer over the word that you want to add to the dictionary or select the word.

2. Right-click the word directly in the cell or in the Formula bar.

3. On the context menu, select Add to Dictionary.

To add a new word directly to the Custom dictionary, follow the steps below:

1. On the Tools menu, select Custom Dictionary.

2. On the Custom Dictionary dialog menu, enter the word you want to add.

3.Click or press Enter.

4.Click Done to finish.

Use third-party dictionaries

To extend the vocabulary available in MyOffice Spreadsheet, you can use third-party dictionaries in .dic format. Simply follow the steps below:

1. In the Custom Dictionary dialog box, click Import.

2. In the opened file manager window, select a .dic file and click Open.

When finished, the contents of the dictionary will appear in your dictionary.

Delete words from the dictionary

If necessary, you can remove words previously added to the Custom dictionary.

To remove a word using the Custom Dictionary menu, follow the steps below:

1. On the Tools menu, select Custom Dictionary.

2. In the Custom Dictionary dialog box, place the pointer on the word you want to remove from the dictionary and click Delete.

3. Click Done to finish.

To remove a word without using the Custom Dictionary window, follow the steps below:

1. Place the pointer over the word you want to remove or select this word.

2. Right-click the word directly in the cell or in the Formula bar.

3. On the context menu, select Remove from Dictionary.

To enable or disable grammar checking, on the Tools menu, select Spelling and Grammar and then Check grammar.

Enabling or disabling grammar checking applies to the current document and doesn't affect other opened documents.

Grammar checking basics

•The grammar checking language is selected automatically depending on the first letter of the cell.

•The grammar checking is launched when the Space bar is pressed, or the Enter key is pressed, provided that the sentence is completed.

•A sentence with a grammar mistake is underlined with a blue wavy line both in the cell and in the Formula bar.

•Formulas and values are not checked.