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.
ALT+SHIFT+RIGHT ARROW KEY Groups the selected rows or columns.
ALT+SHIFT+LEFT ARROW KEY Unroups the selected rows or columns.