Hiding Rows and Columns

Microsoft Excel 2010

If you don’t want to display or print certain rows and columns – hide them!

Hide Rows & Columns  

To hide rows or columns:

  1. Select the row(s) or column(s) you wish to hide.
  2. Display the Home ribbon and click on the Format button.
  3. Select Hide & Unhide from the drop list.
  4. Choose to hide the Rows or Column.

    Note:   Hidden rows and columns do not print.

Unhide Rows & Columns  

  1. Select the entire worksheet if you wish to unhide all rows/columns or select the surrounding rows/columns if you only wish to unhide one row or column.

    Example:  If you only wish to unhide column K, select columns J and L in this step.

  2. Display the Home ribbon and click on the Format button.
  3. Select Hide & Unhide from the drop list.
  4. Choose to unhide Rows or Columns.

Additional References