Hiding spreadsheet rows or columns

You can hide selected rows or columns to temporarily prevent them from being viewed on the screen or printed. You can tell that a row or column is hidden because the headings are out of sequence.

To hide rows or columns:
1 Select the rows or columns you want to hide.
2 Choose Row Height (if you're hiding rows) or Column Width (if you're hiding columns) from the Format menu.
3 Type 0.
Tip: You can also hide rows or columns by positioning the pointer at the bottom edge of a row heading or the right edge of a column heading. Then, when you see the double-headed arrow, drag upward or to the left until the row or column disappears.

To show a hidden row or column:
1 Position the pointer at the edge of the row heading or column heading where the row or column is hidden. For example, if column C is hidden, position the pointer between the headings for column B and column D.
2 Drag downward or to the right to reveal the row or column.

Related topic

  Working with spreadsheet cells, rows, and columns

 
Table of contents Index