To move around a spreadsheet, you would usually use the mouse and then click to put the cursor where you want it. You can also use the scroll bars at the right and bottom of the screen to move either vertically or horizontally through the spreadsheet.
However, you can also move the cursor with the cursor movement keys, and there are times when this can be quicker. The following table shows all the ways you can move the cursor.
Key |
Description |
Arrow keys |
The arrow keys move the cursor one cell at a time in the direction of the arrow (up, down, left, or right). |
page up |
Moves up one screen at a time. |
page down |
Moves down one screen at a time. |
home |
Moves to column A in the current row. |
end |
Moves to the last column that contains information in the current row, or to the last column of the whole spreadsheet if the current row contains no information. |
tab |
Moves one cell to the right. |
shift + tab |
Moves one cell to the left. |
ctrl + home |
Moves to the first cell (A1) in the spreadsheet. |
ctrl + end |
Moves to the intersection of the last column and the last row that contains information. |
ctrl + page up |
Moves one screen to the left. |
ctrl + page down |
Moves one screen to the right. |
ctrl + è |
Moves to the next cell on the right that contains information. |
ctrl + ç |
Moves to the next cell on the left that contains information. |
ctrl + é |
Moves to the next cell upwards that contains information. |
ctrl + ê |
Moves to the next cell downwards that contains information. |
See also: