Work with Columns and Rows

• Apr 01, 2018

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.