Chapter 3

EditingData

Once you've gotten the principles of data entry nailed down, you'll need to learn about the ways in which you can modify, or edit, the information you've posted to their cells. I'm going to introduce those editing techniques now, because, as someone once said, “Change is good” (when you need to make a change). And when you're working with Excel, it's easy too.

Changing Your Data

Needless to say, there will be times when you'll need to make changes to at least some of the data you've posted to your worksheet. For example, you may have made an error or two, or a data update may be in order. Excel makes editing easy, too, and as usual, presents you with a couple of options.

First and most simply, you can edit the contents ...

Get Excel 2010 Made Simple 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.