Hide

Hides selected rows, columns or individual sheets.

To access this command...

Choose Format - Rows - Hide.

Choose Format - Columns - Hide.

Choose Sheet - Hide Sheet.


Select the rows or columns that you want to hide, and then choose Format - Row - Hide or Format - Column - Hide.

You can hide a sheet by selecting the sheet tab and then choosing Format - Sheet - Hide. Hidden sheets are not printed unless they occur within a print range.

Note Icon

A break in the row or column header indicates whether the row or column is hidden.


To display hidden rows, columns or sheets

  1. Select the range that includes the hidden objects. You can also use the box in the corner above row 1 and beside column A. For sheets, this step is not necessary.

  2. Choose Format - Row/Column - Show or Format - Sheet - Show.