Datasheet

Getting Started with Excel
chapter 1
15
PART I
•
•
1
•
•
1
Can I edit or delete the information that I
type in a cell?
Yes. You can edit the information either as
you type it or after you type it by pressing
F2 to switch to Edit mode. To edit as you
type, just press F2. To edit after you type,
click the cell and then press F2. To change
an entry completely, enter new information
as described in this section. To delete all the
information in a cell, select the cell and then
press Delete. To delete both information
and cell formatting, see Chapter 3.
Why does my label in cell A1 appear
truncated but my label in cell B1 seems to
occupy both cells B1 and C1?
The information in both cells exceeds their
column widths. When an empty cell such
as C1 appears beside a cell containing an
overly large entry such as B1, information
seems to occupy both cells. However, Excel
actually stores all the information in cell B1;
look at the Formula Bar as you select cell B1
and then cell C1. See Chapter 5 for more.
Enter Dates
1 Select a cell.
2 Type a date in
mm-dd-yyyy or
mm/dd/yyyy format
(either dashes (-) or
slashes (/) will work).
3 Press Enter.
•
The date you typed
appears right-aligned
in the cell you selected
in step 1.
•
The active cell moves
down one row.
4 Repeat steps 1 to 3 to
enter other numbers.
Enter Numbers
1 Select a cell and then
type a number.
2 Press Enter.
•
The number you typed
appears right-aligned
in the cell you selected
in step 1.
•
The active cell moves
down one row.
3 Repeat steps 1 and 2 to
enter other numbers.
04_577691-ch01.indd 1504_577691-ch01.indd 15 6/3/10 10:45 AM6/3/10 10:45 AM