Datasheet

What happens if I click the
Special button in the Go
To dialog box?
Excel displays the Go To
Special dialog box, where
you can set special
conditions for Excel to use
to go to a particular cell.
For example, if you select
the Comments option,
Excel selects all cells that
contain comments. If you
select the Formulas
option, Excel selects all
cells that contain
formulas.
Where does Excel place
the cell pointer when I
move a screen at a time?
The cell pointer remains in
the same relative position
on the screen when you
press the Page Up or Page
Down keys. For example,
if D10 is the active cell
while viewing rows 1 to
27 and you press the Page
Down key, then Excel
displays D37 as the active
cell. However, the cell
pointer does not move if
you click in the horizontal
scroll bar.
What happens when I
press the Page Down key?
Excel displays the next
page of rows. For example,
if you are viewing rows 1
to 27 on one screen and
you press the Page Down
key, then Excel displays
rows 28 to 54.
Is there an easy way to
move one screen to the
right or left?
Yes. You can click a blank
area in the horizontal
scroll bar that runs across
the bottom of the screen.
4 Press the up-arrow key.
•
Excel moves the cell pointer to the
first cell in the column containing
information.
You can use the End key with any
arrow key to move to the first or last
cell in the row or column containing
information.
You can press Ctrl+Home to move to
cell A1.
5 Press F5.
The Go To dialog box appears.
6 Type a cell address.
7 Click OK.
Excel moves the cell pointer to the
address you typed.
PART I
Getting Started with Excel
17
chapter 1
•
7
6
05_181706 ch01.qxp 1/31/08 9:44 PM Page 17