Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
Navigation using Mouse
Use Scroll bar or mouse over and directly click on the cell

You may double click cell to edit (Shortcut: F2 )
 
Selection using Mouse
Use mouse , mouse over and select the required cells
 
Data Navigation in Keyboard
Up Arrow Moves Up by one cell
Down Arrow Moves Down by one cell
Left Arrow Moves left
Right ArrowMoves one cell to Right
[Ctrl]+UpGoes to Top row of the Data
[Ctrl]+DownGoes to Bottom row of the Data
[Ctrl]+LeftGoes to first column cell with data
[Ctrl]+RightGoes to last column of the data
[Ctrl]+HomeReturns to Topmost left cell of a Data range
[Ctrl]+EndReturns to Bottom most Right cell of a Data range
 
Select with Keyboard
[Ctrl]+[Shift]+UpSelects from current cell to Top row of the Data
[Ctrl]+[Shift]+DownSelects from current cell to Bottom row of the Data
[Ctrl]+[Shift]+LeftSelects from current cell to first column of the data
[Ctrl]+[Shift]+RightSelects from current cell to last column of the data
Navigation within Workbook with Keyboard
[Ctrl]+[PageDown]Navigate to the next sheet
[Ctrl]+[PageUp]Navigate to the previous sheet