Chat with us, powered by LiveChat

How to Hide & Unhide Columns in Excel

How to Hide Columns and Rows in Excel

You can hide rows and columns in a worksheet from view. Data isn’t deleted, but simply hidden until it is unhidden again.

Hide Rows or Columns

You can easily hide whole rows or columns from view.

  1. Select the row(s) or column(s) you want to hide.
  2. Click the Format button under the Home tab.
  3. Select Hide & Unhide.
  4. Select Hide Rows or Hide Columns.
    Hide Rows or Columns

    Right-click the selected row(s) or column(s) and select Hide from the contextual menu.

The selected row(s) or column(s) are hidden from view.

Unhide Rows or Columns

  1. Select the rows or columns that surround the hidden row(s) or column(s).
  2. Click the Format button under the Home tab.
  3. Select Hide & Unhide.
  4. Select Unhide Rows or Unhide Columns.
    Unhide Rows or Columns

    Right-click the selected row(s) or column(s) and select Unhide from the contextual menu.

The data reappears once again.