Hints and tips home » Excel hints and tips » Quickly hide and unhide rows and columns

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

Added by Alan on 16th September 2006

More Excel hints and tips, like:

• Adding cells, Rows & columns
• Charts
• Formula for last day of month