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

 


Table of contents | Index