Microsoft Office Tutorials and References
In Depth Information
Correcting and expanding upon worksheet data
Click the Format arrow to the right of the Find what field, and then in the list, click
Clear Find Format to remove the format from the Find What field.
In the Find what field, enter Contoso .
In the Replace with field, enter Northwind Traders .
Click Replace All , which causes Excel to display a message box indicating that Excel
made three replacements.
Click OK to close the message box.
Click Close to close the Find and Replace dialog box.
CLEAN UP Close the AverageDeliveries workbook, saving your changes if you
Correcting and expanding upon
After you enter your data, you should take the time to check and correct it. You do need to
verify visually that each piece of numeric data is correct, but you can make sure that your
worksheet’s text is spelled correctly by using the Excel spelling checker. When the spelling
checker encounters a word it doesn’t recognize, it highlights the word and offers
suggestions representing its best guess of the correct word. You can then edit the word directly,
pick the proper word from the list of suggestions, or have the spelling checker ignore the
misspelling. You can also use the spelling checker to add new words to a custom dictionary