Bookmark page
Printable version
Course updates
Opening and navigating workbooks
To open an Excel file, use the Open button on the standard toolbar
or the shortcut keys Ctrl + O.
Try it!
Open the file Sales report.xls from the course files folder.
Using the mouse to select and navigate
 |
Use to select a cell or range of cells |
 |
Use to select a column, by clicking on a column header |
 |
Use to select a row, by clicking on a row header |
 |
Hold over a scroll bar, click and drag to scroll |
Try it!
Practice using the mouse to select cells, rows and columns in Sales report.xls.
Using keyboard shortcuts
The following keyboard shortcuts can be used to navigate within and between worksheets in a file.
| Arrow keys | Move one cell right, left, up or down |
| Ctrl + arrow keys | Move to the first or last cell that contains data in a row or column |
| Page Up, Page Down | Move up or down a worksheet |
| Ctrl + Page Up, Ctrl + Page Down | Move to the next or previous worksheet |
| Ctrl + Home, Ctrl + End | Move to start or end of spreadsheet |
Try it!
Practice using the shortcut keys listed above in Sales report.xls.
