v F5 – Go to cell reference
|
v Ctrl + Down. Used to navigate to the bottom-most cell of that column.
|
v Ctrl + Up. Used to navigate to the top-most cell of that column.
|
v Ctrl + Left. Used to navigate to the left-most cell of that row.
|
v Ctrl + Right. Used to navigate to the right-most cell of that row.
|
v Ctrl + Shift + Down. Used to select all the cells from the selected cell till the bottom-most cell of that column.
|
v Ctrl + Shift + Up. Used to select all the cells from the selected cell till the top-most cell of that column.
|
v Ctrl + Shift + Left. Used to select all the cells from the selected cell till the right-most cell of that row.
|
v Ctrl + Shift + Right. Used to select all the cells from the selected cell till the left-most cell of that row.
|
v Ctrl + *. Used to select the entire table to data. This works only with when selected cell is a part of that table.
|
v Ctrl + A. Used to Select entire worksheet.
|
v Ctrl + Home. Used to move to the beginning of the worksheet.
|
v Ctrl + SpaceBar. Used to select an entire column in a worksheet.
|
v Shift + SpaceBar. Used to select an entire row in a worksheet.
|
v Ctrl + +. Used to insert a new row or column, based on user-input.
|
v Ctrl + -. Used to delete an existing row or column, based on user-input.
|
v Ctrl+pg up/down. Switching between worksheets.
|
These shortcuts have made me neglect using my mouse to a great extent, effect of which is less time taken to do any work on my data!