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 ...

Get Microsoft® Office Excel® 2003 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.