Datasheet

Chapter 1: Getting Started
5
When you enter numbers as
text, an Error button ( )
may appear. Excel is checking
to see if you entered the
number as text by mistake.
You should click the button
and then click Ignore Error.
1
3
3
2
1
2
ENTER NUMBERS AS TEXT
1 Move to the cell in which
you want to enter a
number as text.
2 Type an apostrophe
followed by the number
you want to enter.
3 Click the check mark.
Excel enters the number
into the cell.
Alternatively, press Enter.
If you receive an error,
click the Error button
( ) and then click
Ignore Error.
ENTER DATES
1 Move to the cell in which
you want to enter a date.
2 Type the date you want
to enter.
3 Click the check mark.
Excel enters the date into the cell.
Alternatively, press Enter.
When you press Enter after
typing an entry into a cell, by
default Excel moves down one
cell. If you want Excel to move
to the cell to the right, press
the right-arrow key or the Tab
key. If you want Excel to move
up, press the up-arrow key.
If you want Excel to move to
the left, press Shift+Tab or
the left-arrow key.
By default, when you press the
Enter key after typing an entry,
Excel moves down one cell. You can
change the default location to
which Excel moves. Click the Office
button. A menu appears. Click
Excel Options in the lower-right
corner. The Excel Options dialog
box appears. Click Advanced. Make
sure the After Pressing Enter check
box is selected and then choose
Right, Up, or Left in the Direction
field to cause Excel to move right,
up, or left when you press Enter.
04_132296 ch01.qxp 5/24/07 12:53 PM Page 5