Excel - Move Around

Excel provides a number of ways to move around a sheet using the mouse and the keyboard.
First let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot.

OrderDate	Region	Rep	Item	Units	Unit Cost	Total
1/6/2010	East	Jones	Pencil	95	1.99	189.05
1/23/2010	Central	Kivell	Binder	50	19.99	999.5
2/9/2010	Central	Jardine	Pencil	36	4.99	179.64
2/26/2010	Central	Gill	Pen	27	19.99	539.73
3/15/2010	West	Sorvino	Pencil	56	2.99	167.44
4/1/2010	East	Jones	Binder	60	4.99	299.4
4/18/2010	Central	Andrews	Pencil	75	1.99	149.25
5/5/2010	Central	Jardine	Pencil	90	4.99	449.1
5/22/2010	West	Thompson	Pencil	32	1.99	63.68
6/8/2010	East	Jones	Binder	60	8.99	539.4
6/25/2010	Central	Morgan	Pencil	90	4.99	449.1
7/12/2010	East	Howard	Binder	29	1.99	57.71
7/29/2010	East	Parent	Binder	81	19.99	1,619.19
8/15/2010	East	Jones	Pencil	35	4.99	174.65

Moving with Mouse

You can easily move the insertion point by clicking in your text anywhere on the screen. Sometime if sheet is big then you can not see a place where you want to move. In such situation you would have to use the scroll bars, as shown in the following screen shot:
You can scroll your sheet by rolling your mouse wheel, which is equivalent to clicking the up-arrow or down-arrow buttons in the scroll bar.

Moving with Scroll Bars

As shown in the above screen capture, there are two scroll bars: one for moving vertically within the sheet, and one for moving horizontally. Using the vertical scroll bar, you may:

• Move upward by one line by clicking the upward-pointing scroll arrow.
• Move downward by one line by clicking the downward-pointing scroll arrow.
• Move one next page, using next page button (footnote).
• Move one previous page, using previous page button (footnote).
• Use Browse Object button to move through the sheet, going from one chosen object to the next.

Moving with Keyboard

The following keyboard commands, used for moving around your sheet, also move the insertion point:

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 move box by box or sheet by sheet.Now click in any box containing data in the sheet. You would have to hold down the Ctrl key while pressing an arrow key, which moves the insertion point as described here:

Key Combination	Where the Insertion Point Moves
Ctrl +	To the last box containing data of the current row
Ctrl +	To the first box containing data of the current row
Ctrl +	To the first box containing data of the current column
Ctrl +	To the last box containing data of the current column
Ctrl + PageUp	To the sheet in the left of the current sheet.
Ctrl + PageDown	To the sheet in the right of the current sheet.
Ctrl + Home	To the beginning of the sheet
Ctrl + End	To the end of the sheet

Moving with Go To Command

Press F5 key to use Go To command, which will display a dialogue box where you will have various options to reach to a particular box.
Normally we use row and column number ,for example K5 and finally press Go To button.