Microsoft Office Tutorials and References
In Depth Information
Navigate a Worksheet
Navigate a
Worksheet
You can use a few keyboard techniques that make it
easier to navigate data after you have entered it in a
worksheet.
It is usually easiest to use your mouse to click in the
next cell you want to work with. If you are using
Excel on a tablet or PC that has a touchscreen, then
you can tap the next cell you want to use. However,
if you are entering data, then using the keyboard to
navigate to the next cell is often faster because your
hands do not have to leave the keyboard.
Keyboard Techniques for Navigating a Worksheet
Press
To move
Left one cell
Right one cell
Up one cell
Down one cell
To the beginning of the current row
Home
Down one screen
Up one screen
One screen to the right
+
One screen to the left
+
To the beginning of the worksheet
Home
+
To the bottom-right corner of the used portion of the worksheet
+
In the direction of the arrow to the next non-blank cell if the current cell is blank, or to the last non-blank
cell if the current cell is not blank
+arrow keys
Search JabSto ::




Custom Search