MS Excel - Find & Replace, MS Excel - Spell Check

MS Excel - Find & Replace

MS Excel Provides Find & Replace option for finding text within the sheet.

Find and Replace Dialogue

Let us see how to access Find & Replace Dialogue.

To access the Find & Replace, Choose Home -> Find & Select -> Find or press Control + F Key.See below image.

You can see the Find and Replace dialogue as below.

You can replace the found text with the new text with Replace tab

Exploring options

Now Let us see various options available under the Find dialogue.

• Within: Specifying the search should be in Sheet or workbook.
• Search By: Specifying the internal search method by rows or by columns.
• Look In: If you want to find text in formula as well then select this option.
• Match Case: If you want to match the case like lower case or upper case of words then check this options
• Match Entire Cell Content: If you want to exact match of the word with cell then check this option.

MS Excel - Spell Check

MS Excel Provides feature of Word Processing program Spelling check. We can get rid of the spelling mistakes with the help of spelling check feature.

Spell Check basis

Let us see how to access spell check.

• To access the spell checker, Choose Review ➪ Spelling or press F7.
• To check the spelling in just a particular range, select the range before you activate the spell checker.
• If the spell checker finds any words it does not recognize as correct, it displays the Spelling dialogue with suggested options.

Exploring options

Let us see various options available in spell check dialogue.

• Ignore Once: Ignore the word and continues the spell check.
• Ignore All: Ignore the word and all subsequent occurrences of it.
• Add to Dictionary: Add the word to the dictionary.
• Change: Change the word to the selected word in the Suggestions list.
• Change All: Change the word to the selected word in the Suggestions list and change all subsequent occurrences of it without asking.
• AutoCorrect: Add the misspelled word and its correct spelling (which you select from the list) to the AutoCorrect list.