Hide and unhide rows and columns without a mouse
Excel shortcuts November 24th, 2007
To hide the selected rows enter CTRL+9.Entire row can be selected by pressing (shift+spacebar) together and then holding the shift key use the up or down arrow key to select more than one row.
To unhide any hidden rows within a selection enter CTRL+SHIFT+(
Similarly, to hide the selected columns enter CTRL+0.Entire column can be selected by pressing (Ctrl+spacebar) together and then holding the shift key use the right or left arrow key to select more than one column.
To unhide any hidden columns within a selection enter CTRL+SHIFT+)
Share ThisPopularity: 4%
