ALL ABOUT OFFICE

EXCEL

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT

Moving Around the Worksheet

To enter data in a cell you can just click on that cell and type.  If you know the reference of the cell you want to move to, you can click in the Name Box  at the top left of the Excel screen and enter the reference, when you press Enter you will move to that cell.  If you press CTRL and G together the Goto window will appear and you can enter the cell you wish to move to:

You can quickly move around your spreadsheet using the following key combinations:

HOME

Moves to the beginning of the row

CTRL+HOME

Moves to the beginning of the worksheet

CTRL+END

Moves to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is normally A1

PAGE DOWN

Moves down one screen

PAGE UP

Moves up one screen

ALT+PAGE DOWN

Moves one screen to the right

ALT+PAGE UP

Moves one screen to the left

CTRL+PAGE DOWN

Moves to the next sheet in the workbook

CTRL+PAGE UP

Moves to the previous sheet in the workbook

CTRL+BACKSPACE

Scrolls to display the active cell

CTRL + i

Moves to the bottom edge of the current data area and eventually to the bottom of the worksheet (row 65,536) when pressed again.

CTRL + h

Moves to the top of the current data area and eventually to the top of the worksheet when pressed again.

CTRL + g

Moves to the right edge of the current data area and eventually to the last column (IV) when pressed again.

CTRL + f

Moves to the left edge of the current data area and eventually to the first column when pressed again.

If you press the END key you switch on ?End Mode ? and can then press the arrow keys to move around your worksheet in the same way as the CTRL key combinations above.  Other useful End Mode combinations are:

END, HOME

Moves to the last cell in the worksheet (the same as pressing CTRL + END).

END, ENTER

Moves to the last cell to the right in the current row that is not blank.

By pressing the Scroll Lock key you can scroll around the worksheet without moving the selection from the active cell (i.e. if you had selected cell A1 before scrolling your cursor will still stay over that cell).  The following key combinations will scroll you around the worksheet with Scroll Lock  on:

SCROLL LOCK, HOME

Scrolls to the cell in the upper-left corner of the window

SCROLL LOCK, END

Scrolls to the cell in the lower-right corner of the window.

SCROLL LOCK, h

Scrolls one row up.

SCROLL LOCK, i

Scrolls one row down.

SCROLL LOCK, f

Scrolls one column left.

SCROLL LOCK, g

Scrolls one column right.

When you have finished scrolling, press CTRL + BACKSPACE to return to the active cell.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk