It is not difficult to move around in a work sheet. If you click a cell to make it active, pressing the Enter key will make the cell immediately below it active. Basically you have moved the active property to the next cell below. If you keep pressing Enter, you will see the enhanced border move down the column from cell to cell.
If you use the Up arrow key you can move to the cell just above. The Down arrow key will move you to the cell just bellow. The right arrow key will move one cell to the right, and the Left arrow key will move one cell to the left.
Using the Page up key will move you up one full screen (grid of cells). Using the Page down key will move you down one full screen. Alt + Page up and Alt +Page down move you one full screen left and right respectively.
If you have a block of cells, pressing Ctrl + Left arrow will move you to the left side (beginning) of the block. Ctrl + Right arrow will move you to the right side (end) of the block. Similarly, Ctrl + Up Arrow will move you to the top of the data block, and Ctrl + Down arrow will move you to the bottom.
If you press the Ctrl + Home keys you will move to the top left of the data area on your work sheet, and Ctrl + End will move you to the bottom right.
Another useful way to get around in a work sheet is to use the go to feature. Click on the Edit menu, and select Go To (Edit->Go To). You will then see the Go To dialogue box.
Type a cell reference (the column letter and row number for a cell) in the reference text box, and click OK. You will be moved to the precise cell that you entered. If you have used Go To previously while you were working, there will be a list of recently visited cells that you can choose from. Pressing the Ctrl + G keys will also invoke the Go To dialogue box. |