Section 1.2. Editing Data

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:

1. Move to the cell you want to edit.

   Use the mouse or the arrow keys to get to the correct cell.

2. 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.

3. 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.

   ---

   Tip: If you start typing new information into a cell, and you decide you want to move to an earlier position in your entry (to make an alteration, for instance), just press F2. The cell box still looks the same, but you're now in edit mode, which means that you can use the arrow keys to move within the cell (instead of moving from cell to cell). You can press F2 again to return to the normal data entry mode.

   ---

   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.

   

   Figure 1-6. Overlapping cells can create great headaches . For example, if you type a large amount of text into A1, and then you type some text into B1, you'll only see part of the data in A1 on your worksheet (as shown here). The rest is truncated. But if, say, A3 contains a large amount of text and B3 is empty, the content in A3 is displayed over both columns, and you don't have a problem.