Menu

Keyboard

Toolbar

Select the entire current column

Ctrl + Spacebar

Select the entire current row

Shift + Spacebar

Select the region around the active cell (area enclosed by blank rows and blank columns)

Ctrl + Shift + *

Extend selection by one cell

Shift + Arrow Key

Extend selection to last non-blank cell (column or row)

Ctrl + Shift + Arrow Key

Select to beginning of row

Shift + Home

Select to beginning of worksheet

Ctrl + Shift + Home

Select to end of worksheet

Ctrl + Shift + End

Select down one screen view

Shift + Page Down

Select up one screen view

Shift + Page Up

Select all objects on worksheet (one must be selected first)

Ctrl + Shift + Spacebar

Select only cells that are directly referred to by formulas in the selection

Ctrl + [

Note:  Press again to return to normal.

Copy formula from cell above

Ctrl + '

Copies contents of cell above

Ctrl + Shift + '

Note:  If a formula is present, copies result of formula only and not the formula itself.