Navigating around your spreadsheet

Navigating around your spreadsheet

Eingetragen bei: Englisch, Excel, Tips | 0

Navigation & Selection

One problem many users find when working with a large amount of data in Excel, is navigating around their data, and making selections.

Here are some shortcuts that can make your life very much easier.

Shift + [arrow key]:
selects each of the cells visited whilst you are holding the shift key.  This is the same as clicking and dragging the cursor.

Ctrl + [arrow key]:
jumps to the last cell in the block of data, in the direction of the arrow (i.e. it stops when it encounters a blank cell in the direction of the arrow).

Ctrl + Shift + [arrow key]:
selects every cell in the block of data in the direction specified by the arrow key.   Extremely useful for selecting a very large amount of cells.

Ctrl + Space:
selects the entire current column.

Shift + Space:
select the entire current row.

Home:
moves the active cell to the first cell in the current row.

Ctrl + Home:
moves the active cell to cell „A1“, i.e. the left top-most cell of the current tab of your workbook.

Ctrl + End:
moves the active cell to the right bottom-most corner of the current tab of your workbook (which is filled with data – it does not go beyond the range of actually used cells).

PgUp / PgDown:
moves up/down through the current tab of the workbook, treating the visible part of the workbook as a page and scrolling on a page by page basis.

Ctrl + Page Up / Ctrl + Page Down:
Moves left and right through the available tabs of the workbook.