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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.