Hiding Columns or Rows

The mouse may be used to hide columns or rows.

To hide a column, first click on the vertical dividing line to the right of the column. Drag the vertical dividing line to the left as far as it will go and then release the mouse button. If there are hidden columns to the right of this column, grab the left side of the vertical dividing line. If the right side of the vertical dividing line is selected, the vertical dividing line for the adjacent hidden column is selected.

To hide a row, first click on the horizontal dividing line at the bottom of the row. Drag the horizontal dividing line up as far as it will go and then release the mouse button. If there are hidden rows above this row, grab horizontal dividing line just below the line. If the top side of the horizontal dividing line is selected, the horizontal dividing line for the adjacent hidden row is selected.

With the Format Menu

Columns and rows can also be hidden with the Data | Format | Column Width and Data | Format | Row Height commands. Select the columns or rows to hide, click the Data | Format | Column Width or Data | Format | Row Height command, and then set the Column Width or Row Height to zero.

See Also

Displaying Hidden Columns or Rows

Selecting a Column or Row Dividing Line

Column Width

Row Height