Hide or unhide rows or columns in Excel

If you want to hide or unhide rows or columns, either to fit them on a screen or print your worksheet on a single page, you can do it in Excel in a few different ways.

Hide rows or columns

In order to hide row or rows, follow these steps.

  1. Select rows you want to hide.
  2. Right-click one of the selected rows and choose Hide.

Now, the selected rows are hidden. The remaining six rows are still visible.

Normally, row numbers or column labels are separated by a single line. If there is a double line, instead of a single, it means that there are some items hidden.

In a similar fashion, you can hide columns.

  1. Select columns you want to hide.
  2. Right-click one of the selected column labels and click Hide.

Unhide rows or columns

To unhide the hidden values, select two-row numbers below and above the hidden items and click Unhide.

To unhide columns, click column labels on the left and right of the hidden columns and click Unhide.

Hide rows or columns with a shortcut

You can also hide rows and columns with a keyboard shortcut.

You can use Ctrl + 9 to hide rows, and Ctrl + 0 to hide columns.

If you select a few rows and use Ctrl + 9, it will hide these rows.

But you have to be careful if you choose Ctrl + 0 (hide columns) instead it will hide all columns. In this case, in each column there are four cells selected, therefore all columns will be hidden.

Instead of selecting entire rows or columns, you can select a single cell.

If you choose cell C7 and then Ctrl + 9, it will hide row 7. If you use Ctrl + 0, it will hide column C.

Unhide rows or columns with a shortcut

You can also use a keyboard shortcut to unhide hidden rows and columns.

Ctrl + Shift + 9 – unhide rows

Ctrl + Shift + 0 – unhide columns