What is this? From this page you can use the Social Web links to save Hide and unhide rows and columns without a mouse to a social bookmarking site, or the E-mail form to send a link via e-mail.

Social Web

E-mail

E-mail It
November 24, 2007

Hide and unhide rows and columns without a mouse

Posted in: Excel shortcuts

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+)


Return to: Hide and unhide rows and columns without a mouse