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

Recent Comments

David Clark: TOTALLY USEFUL. a lot easier than writing CODE

federico: Thanks for the tip this help me figured out a way to make a list of a karaoke collection the easy ...

John: The only problem with this method is if your data will be used in a Pivot Table. The Pivot Table wi...

Nirmala: Good marco. Something that I was trying to figure out for a long time. Thanks. It helped me a lot.. ...

KRISS: Thank you for filling in one of many gaps in Microsoft's "help" information.

iceman: This is nice

judgepax: Thank you for the wonderful macro! No one else seemed to know how to do this, so you just saved me ...

Riddha: This is cool! Really helped me to move my excel skills a notch up! Thanks!

malcolm: thank you massivley. that little problem was truley annoying.

JT: THANK YOU!!!!!!!!!!!!!!!!

Nicki Soules: Thank you for this information. Sounds like we are not the only computer people that have had this ...

Daniel: Another method is Data - Text to Columns - Choose Fixed Width you can do more than 2 splits this...