O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Editing a Worksheet

NO MATTER HOW GOOD WE THINK we are, we all make mistakes. Typos are a given when you are dealing with large amounts of data. So, how do you fix them? Obviously, you can click in any offending cell and retype the entry correctly, but that’s not always the fastest method.

If you don’t want to have to retype the entry, you can edit the existing entry by following these steps:

1.
Double-click the cell, or press F2, to select the cell in Edit mode. The insertion point blinks inside the cell at the end of the entry and the status bar indicates that you are in Edit mode, as shown in Figure 1-17.
Figure 1-17. Making a data entry correction in Excel.
2.
Use the arrow keys to place the insertion point at the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required