5
weite the key
following acrous
keyboard shortcuts for the
a Go to the end
of
from cell to cell in a table
in bright to left direction.
a low.
To move
Answers
Answer:
In This Article
By Faithe Wempen
Part of Digital Literacy For Dummies Cheat Sheet
Anyone who works with Excel spreadsheets knows that they can become extremely long and complex. Here are some keyboard tricks for getting around in a spreadsheet quickly and easily.
Press This To Move . . .
Arrow keys One cell in the direction of the arrow
Tab One cell to the right
Shift+Tab One cell to the left
Ctrl+arrow key To the edge of the current data region (the first or last cell that isn’t empty) in the direction of the arrow
End To the cell in the lower-right corner of the window*
Ctrl+End To the last cell in the worksheet, in the lowest used row of the rightmost used column
Home To the beginning of the row containing the active cell
Ctrl+Home To the beginning of the worksheet (cell A1)
Page Down One screen down
Alt+Page Down One screen to the right
Ctrl+Page Down To the next sheet in the workbook
Page Up One screen up
Alt+Page Up One screen to the left
Ctrl+Page Up To the previous sheet in the workbook