>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224
Home / Blog /

Tips and Tricks 1: Excel Shortcut to select a Row or Column

Tips and Tricks 1: Excel Shortcut to select a Row or Column

by Brilliance Computer Training Academy & Services
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 select a Column

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.

Share this article

Leave a comment

Your email address will not be published. Required fields are marked *