To select an entire column in Excel use:
ACtrl+Space bar
BCtrl+C
CCtrl+arrow key
DShift+S
ACtrl+Space bar
BCtrl+C
CCtrl+arrow key
DShift+S
Related Questions:
Which Excel 2007 feature is used to create a formula that adjusts its cell references relative to the position of the formula in the worksheet?