iSumsoft » Resources » Office » How to Hide or Unhide Rows or Columns in Excel

How to Hide or Unhide Rows or Columns in Excel

This is a quick guide on how to hide a row or column in Excel. In this guide you will learn several ways to show or hide a row or column, and display all hidden rows and columns at the same time.

How to Hide Rows or Columns in Excel

To hide rows or columns in Excel worksheet, select the rows or columns that you want to hide.

Option 1: Right-click and select Hide row or Hide column from the menu that appears,

Hide rows

Option 2: Go to the Home tab, click Format, point to Hide & Unhide, then click Hide Rows or Hide Columns.

Hide columns in Excel

How to Unhide the Hidden Rows or Columns

Option 1: Unhide a row or column by dragging the gridline.

When you find there is a row or column hidden, you can samply drag the gridline to show it.

Display row or column by dragging it

Option 2: Show all hidden rows and columns at the same time

Step 1: Click the Select All button.

Or press Ctrl+A to select all cells on a worksheet.

Select all cells

Step 2: On the Home tab, click Format.

Step 3: Under Visibility, point to Hide & Unhide, and then clck Unhide Rows or Unhide Columns.

Unhide all hidden rows or columns

How to hide or unhide rows or columns using shortcut key

To do: Select a cell that you want to hide its row or columns, then use the following keyboard shortcut keys.

Ctrl + 9: hide the selected rows.

Ctrl + 0: hide the selected columns.

Hide select cell using shortcut key

Ctrl + Shift + (: Unhide the hidden rows within the selection.

Ctrl + Shift + ): Unhide the hidden columns within the selection.