KEYBOARD SHORTCUTS -2

USING CTRL AND OTHER KEYS

Ctrl+;  To enter current date
Ctrl+:  To enter current time

Ctrl+Spacebar To select entire column
Shift+Spacebar To select entire Row

Ctrl++ To insert row
Ctrl+- To delete row

Ctrl+9 Hide row
Ctrl+0 Hide column

Ctrl+SHift ( Unhide row
Ctrl+Shift  ) Unhide column

Ctrl+Pageup Go to previous worksheet
Ctrl+Pagedown Go to next worksheet
Ctrl+Home Go to top left corner (Cell A1)
Ctrl+End  Go to End of data table ?

Ctrl+ <- (back key) Move one word to left
Ctrl+ -> (forward key) Move one word to right
Ctrl+ Up  key Move up to blank cell
Ctrl+ Down key  Move down till blank cell

Ctrl+ Shift+ <- (back key) Move to left most data area.
Ctrl+Shift -> (forward key) Move to right most data area.
Ctrl+Shift+ Up  key Move up to top most data  cell
Ctrl+ Shift+ Down key  Move to bottom most data cell

Ctrl+ . Move to data area corners in clockwise direction.

Ctrl+ Del Delete to end of word.