1.2. Editing Data
Every time you start typing in a cell, Excel erases any existing content in that cell. (You can also quickly remove the contents of a cell by just moving to it and pressing Delete.)
If you want to edit cell data instead of just replacing it, you need to put the cell in edit mode , like this:
Move to the cell you want to edit.
Use the mouse or the arrow keys to get to the correct cell.
Put the cell in edit mode by pressing F2.
Edit mode looks almost the same as ordinary text entry mode. The only difference is that you can use the arrow keys to move through the text you're typing and make changes. (When you aren't in edit mode, pressing these keys just moves you to another cell.)
If you don't want to use F2, you can also place a cell in edit mode by double-clicking it.
Complete your edit.
Once you've modified the cell content, you can press Enter to commit your change or Esc to cancel your edit and leave the old value in the cell. Alternatively, you can turn off edit mode (press F2 again), and then move to a new cell to commit your change. As long as you stay in edit mode, Excel won't let you move to another cell.
As you enter data, you may discover the Bigtime Excel Display Problem (known to aficionados as BEDP): cells in adjacent columns can overlap one another. Figure 1-6 shows the problem. One way to fix BEDP is to manually resize the column, as shown in Figure 1-4. Chapter 2 tackles editing in more detail and shows how you can deal with these dilemmas by resizing columns (Chapter 2). Chapter 4 shows you how to wrap multiple lines of text in a single cell.