Work with Columns and Rows

The key combinations that allow you to display, hide or group columns and rows in a worksheet are listed in the following table.

Shortcut	Description
CTRL+9	Hides the selected rows.
CTRL+SHIFT+9	Displays the hidden rows.
CTRL+0	Hides the selected columns.
CTRL+SHIFT+0	Displays the hidden columns.