Navigating in the Worksheet

Navigating in the Worksheet

How you can move from one place to another in Microsoft Excel? Here is the ways:

·  To move to a particular cell (quick way)

·  Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen). In the example shown the cell reference J50 has been entered. When you press the Enter key you will jump to the cell you entered.

·  To move from cell to cell using the keyboard

·  To move from cell to cell, use one of the following key or combination keys:

Icon	Function
→	One cell to the right.
←	One cell to the left.
↓	One cell down.
↑	One cell up.
Ctrl + →	To the right-hand edge of the current region.
Ctrl + ←	To the left-hand edge of the current region.
Ctrl + ↓	To the bottom edge of the current region.
Ctrl + ↑	To the top edge of the current region.
Home	To the first cell in the row.
Ctrl + Home	To the first cell in the worksheet.
Ctrl + End	To the lowest right-hand cell in the worksheet that contains a data entry.
Page Down	One screen down.
Page Up	One screen up.
Alt + Page Down	One screen to the right.
Alt + Page Up	One screen to the left.