Datasheet

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
the F2 key on your keyboard to switch to
Edit mode. To edit as you type, just press
F2. To edit after you type, click the cell to
select it and then press F2. To change an
entry completely, enter new information as
described in this section. To delete all of
the information in a cell, select the cell and
press Delete. To delete both information
and cell formatting, see Chapter 3.
Why does my label in cell A1 appear
truncated while 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
over-large entry such as B1, information
seems to occupy both cells. However, Excel
actually stores all of the information in cell
B1; look at the Formula Bar as you select
cell B1 and then cell C1. The information
in B1 is also hiding part of the over-large
entry in A1. To view all of an over-large
entry on the worksheet, widen the column.
See Chapter 6 for details.
Enter Numbers
1 Select a cell and type a number.
2 Press Enter.
•
The number you typed appears
right aligned in the cell you
selected in Step 1.
•
The cell pointer moves down one
row.
3 Repeat Steps 1 and 2 to enter other
numbers.
Enter Dates
1 Select a cell.
2 Type a date in mm-dd-yy format,
separating the parts of the date with
either dashes (-) or slashes (/).
3 Press Enter.
•
The date you typed appears right
aligned in the cell you selected in
Step 1.
•
The cell pointer moves down one
row.
4 Repeat Steps 1 to 3 to enter other
numbers.
PART I
Getting Started with Excel
13
chapter 1
1
•
•
1
•
•
05_181706 ch01.qxp 1/31/08 9:44 PM Page 13