MODULE 4 - Spreadsheets
Navigating through worksheets and workbooks
To move to a cell using the mouse · Place the mouse pointer on the cell and click.
To move to a particular cell (quick way) · Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen, as illustrated). In the example shown the cell reference J9 has been entered. When you press the Enter key you will jump to the cell you entered.
To move from cell to cell using the keyboard ·
To move from cell to cell, use one of the following methods:
Press this: To move:
® One cell to the right.
One cell to the left.
¯ One cell down.
One cell up.
Ctrl + ® To the right-hand edge of the current region.
Ctrl+ To the left-hand edge of the current region.
Ctrl + ¯ To the bottom edge of the current region.
Ctrl + To the top edge of the current region.
Home To the first cell in the row.
Ctrl+Home To the first cell in the worksheet.
Ctrl+End To the lowest right-hand cell in the worksheet that contains
a data entry.
Page Down One screen down.
Page Up One screen up.
Alt+PgDn One screen to the right.
Alt+PgUp One screen to the left.
To move within a selection · Use one of the following key combinations:
Press this: To move the active cell:
Tab To the right one cell.
Shift+Tab To the left one cell.
Enter One cell down.
Shift+Enter One cell up.
To move between worksheets using the mouse · Place the mouse pointer on the sheet tab you want, and click.
To move between worksheets using the keyboard · Use Ctrl+PgDn to
move to the next sheet.· Use Ctrl+PgUp to move to the previous
sheet.
To move using Go To · From the Edit menu, choose Go To in order to display the Go To dialog box.· In the Reference text box type the cell reference, or click a range name in the Go To list box and then select OK.
To move to a different worksheet within a workbook · Click on the appropriate worksheet tab displayed along the bottom of the worksheet.
To move to the first or last worksheet in a workbook · To move to the last worksheet in a workbook, click on this arrow: · To move to the first worksheet in a workbook, click on this arrow: