Moving around a spreadsheet

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:

Moving to a particular cell

Worksheets