Hiding and Unhiding Rows and Columns

Hiding and Unhiding Rows and Columns

Excel provides shortcuts for quickly hiding and unhiding rows and columns from the keyboard. To hide rows or columns, select them before pressing the shortcut. To unhide rows or columns, select cells in the rows or columns around them, and then press the shortcut.

Shortcuts for Hiding and Unhiding Rows and Columns

Hide all selected rows

[Ctrl] - [9]

Hide all selected columns

[Ctrl] - [0]

Unhide hidden rows in the selection

[Ctrl] - [Shift] - [(]

Unhide hidden columns in the selection

[Ctrl] - [Shift] - [)]