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. |