Tips and Tricks 1: Excel Shortcut to select a Row or Column
- To select a column of an active cell, press Ctrl + Spacebar or click on the column border.
- To select a row of an active cell, press Shift + Spacebar or click on the row border.
Excel Shortcut to hide a Row or Column
Ctrl + 0 hides the column of the active cell.
Ctrl + 9 hides the column of the active cell
However, I found that these keys only work when pressing the 0 above the Qwerty keyboard. Those in the numerical pad does not work.