Moving Around Your Cursor
When
you want to activate a cell in order to insert, edit or format the
content, there is a number of ways to do this.
You
can use the:
How To Activate A Cell Using The Mouse
SUMMARY
Position
the mouse pointer over the cell you want to activate.
Click
the cell to activate it.
|
|
Position the mouse
pointer to the cell
B3.
The
pointer changes to a white plus sign, as shown below.
Click
the cell B3 to activate
it.
The
cell B3 becomes active, as shown below.
|
How To Move To A Cell Using The Keyboard
|
Press
the key on the keyboard as shown in the table below:
-
Press
|
Move to:
|
|
One cell to the right
|
|
One cell to the left
|
|
One cell down
|
|
One cell up
|
<Ctrl>
+
|
Last cell to the right
of the current region
|
<Ctrl>
+
|
First cell to the left
of the current region
|
<Ctrl>
+
|
Last cell to the bottom
of the current region
|
<Ctrl>
+
|
First cell to the top of
the current region
|
<Home>
|
First cell in the row
|
<Ctrl> + <Home>
|
First cell in the
worksheet
|
<Ctrl> + <End>
|
Last cell in the
worksheet which contains data
|
Page Down
|
One screen down
|
Page Up
|
One screen up
|
<Alt> + Page
Down
|
One screen right
|
<Alt> + Page Up
|
One screen up
|
|
How To Move Around Using The Go To Command
SUMMARY
Click
the Home tab.
In
the Editing group,
click Find & Select >>
Go To.
In
the Reference box,
type the cell reference you want to move to.
Click
the OK button.
|
TIPS
|
Click
the Home
tab, in the Editing
group, click Find
& Select >> Go To.
The
Go To dialog box appears.
I
n
the Reference
box, type z100.
You
want to go to the cell z100.
Click
the OK
button.
Excel
brings you to the cell Z100.
|
How To Move To A Cell Using The Name Box
SUMMARY
Click
the Name Box.
Type
the cell reference.
Press
<Enter>.
|
|
O
n
the formula bar, click
the
Name
Box.
The
cell reference is highlighted. The cell reference in the Name
box shows the current active cell.
Type
z100.
You
want to move to cell z100.
Press
<Enter>.
Excel
sends you to cell z100.
|
How To Move Within A Selected Range
SUMMARY
Highlight
the range where you want to enter data.
Press
<Enter> or <Tab> to move the active
cell within the selected range.
|
TIPS
|
Highlight the range
B2:D4.
The
active cell is bound to move within the highlighted range.
Press
the following key to control your active cell.
-
Press
|
Action:
|
<Tab>
|
Move one cell to the
right
|
<Shift> + <Tab>
|
Move one cell to the
left
|
<Enter>
|
Move one cell down
|
<Shift> +
<Enter>
|
Move one cell up
|
|
How To Move To Other Sheets Within A Workbook
TIPS
|
Move the mouse pointer
to the Sheet2
tab.
The
pointer changes to a white arrow as illustrated below.
Click
the Sheet2
tab.
Sheet2
is brought to the front of all worksheets.
|
