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