You can easily navigate through the sheet by using mouse or the keyboard in many ways.
Try yourself entering the following data in the sheet in a new Excel Sheet. Open and a new file and start typing the data below:
You can easily navigate to the desired insertion point where you want to enter the text by clicking on that point in the sheet. In case the point is not in the visible region, use the scroll bars to navigate to the desired point as shown below:
You can scroll up and down vertically or right and left horizontally by using the wheel on the mouse or the keys marked by up, down, right, left pointing arrows on the scroll bar around the sheet.
As you can see in the image above, there are two types of scroll bars, from which one moves the sheet horizontal and another one vertically.
|Keystroke||Where the Insertion Point Moves|
|Forward one box|
|Back one box|
|Up one box|
|Down one box|
|PageUp||To the previous screen|
|PageDown||To the next screen|
|Home||To the beginning of the current screen|
|End||To the end of the current screen|
You can navigate from one box to another or directly move from one sheet to another. Choose any box on the sheet by moving the cursor of the mouse and try the following commands by holding the Ctrl key while pressing any of the arrow keys.
|Ctrl +||It takes you to the right most box on the sheet containing data in the same row|
|Ctrl +||It takes you to the left most box on the sheet containing data in the same row|
|Ctrl +||It takes you to the top most box on the sheet containing data in the same column|
|Ctrl +||It takes you to the down most box on the sheet containing data in the same column|
|Ctrl + PageUp||It takes you to the sheet on the left of the current sheet|
|Ctrl + PageDown||It takes you to the sheet on the right of the current sheet|
|Ctrl + Home||It takes you to the starting point of the sheet|
|Ctrl + End||To the end of the sheet.|
You can directly go to a box by pressing the F5 which is for Go To command. It will open a dialog box containing options for every box, along with corresponding rows and columns.