Hide Columns or Rows

 

Hide | Unhide

Sometimes it can be useful to hide columns or rows in Excel.

Hide

To hide a column, execute the following steps.

1. Select a column.

Hide Column Example

2. Right click, and then click Hide.

Click Hide

Result:

Hidden Column in Excel

Note: to hide a row, select a row, right click, and then click Hide.

Unhide

To unhide a column, execute the following steps.

1. Select the columns on either side of the hidden column.

Unhide Column Example

2. Right click, and then click Unhide.

Click Unhide

Result:

No Hidden Columns

Note: to unhide a row, select the rows on either side of the hidden row, right click, and then click Unhide.