Excel's Goto command.
Imagine you load a large worksheet loaded into Excel, and find the cursor in the top left cell, A1.You wish to examine a calculation that you know to be somewhere near row 3000. How are you going to get there?
There are, of course, several ways to get there.
| • | You could press the Down arrow key 2999 times. |
| • | You could press and hold the Down arrow key and leave your computer to do the repeating, until the spreadsheet scrolls to where want to be. |
| • | You could do something similar with the PgDn key, which would move rather faster. |
| • | You could place the mouse pointer over the slider in the vertical scroll bar, and move it down until Excel indicates that you have reached row 3000. |
All these ways work, but there is a faster way: use Excel's Goto command. It can be activated
| • | from the Excel menu: Edit | Go To |
| • | by using a shortcut that dates back to the dawn of the PC: the F5 key |
| • | by using a shortcut that has its origins in Apple Macintosh software: Ctrl+G. |
Any of these work, but the one we will use in this tutorial is the F5 key.
To reach row 3000 of the spreadsheet, you simply press F5, and type A3000 into the dialog that then appears.
Dismiss the dialog by clicking OK, or pressing Enter, and you are immediately at the desired spot.
See also