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

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