EXCEL
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.