How to Hide & Unhide Columns 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.
   

   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.
   

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

The data reappears once again.