Some spreadsheet users will have projects that extend far beyond the boundaries of the Excel window. They have to scroll to the right or down long distances. The side scrollbars offer one easy way to move the Excel window in the spreadsheet. If the user's mouse skills are not strong, Excel offers a keyboard trick to move around quickly too. You don't have to have weak mouse skills to enjoy the feature!
The cell at A1 is considered the "home" position for the window. Regardless of where the Excel window is located in the spreadsheet, the depression of the Control Key and the Home key will instantly move the window where A1 is in the top left corner.
 |
This image represents the top corner of the Excel window the user is using at the moment. |
 |
This image represents the top corner of the Excel window AFTER pressing the CTRL+Home keys. Notice the hightlighted cell becomes A1. (Looks like John could study a little more!) |
There is another Control
+ key that also moves the window to a new location in the spreadsheet.
The Control + End will move the Excel window to display
the cell that is on the right-most column and the lowest
row. Some people might call this the "last" cell.
As an aside, you should experiment with the Page Up and Page Down keys to see what happens. The results of all of these CNTL keys should match your intuition of the action. Note, these actions are conceptually similar to many word processing programs.