• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Getting to Know Excel > Checking and Correcting Data

Checking and Correcting Data

Once you’ve entered 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 the text is spelled correctly by using Excel’s spelling checker. When the spelling checker encounters a word it doesn’t recognize, it will highlight the word and offer 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 any words that aren’t in the standard dictionary so that Excel will recognize them later, saving you time by not requiring you to identify the words as correct every time they occur in your worksheets. Once you’ve made a change, you can remove the change as long as you haven’t closed the workbook where you made the change. To undo a change, you click the appropriate toolbar button or open the Edit menu and choose the Undo command. If you decide you want to keep a change, you can use the Redo command to restore it.


If you’re not sure of your word choice, or if you use a word that is almost but not quite right for your meaning, you can check for alternative words using the Thesaurus. A number of other Research tools are also available, such as the Encarta Encyclopedia, which you can refer to as you create your workbook.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint