Excel Move Around

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:

Moving with Mouse

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.

Moving with Scroll Bars

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.

  • Navigate one line upward by clicking the scroll arrow, which is pointing upwards.
  • Navigate one line downwards by clicking the scroll arrow that is pointing downwards.
  • Navigate to the next page by clicking the next page button (footnote).
  • Navigate to the previous page by clicking the previous page button (footnote).
  • Browse Object button will take you directly to the desired location on the sheet.

Moving with Keyboard

Keystroke Where the Insertion Point Moves
Forward Arrow Forward one box
Backword Arrow Back one box
Upward Arrow Up one box
Downard Arrow 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.

Option Description
Ctrl + Forward Arrow It takes you to the right most box on the sheet containing data in the same row
Ctrl + Backword Arrow It takes you to the left most box on the sheet containing data in the same row
Ctrl + Upward Arrow It takes you to the top most box on the sheet containing data in the same column
Ctrl + Downard Arrow 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.

Moving with Go To Command

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.