Hiding Columns or Rows

You can hide columns or rows with the mouse or with the Format menu.

 

With the Mouse

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, select Data | Format | Column Width or Data | Format | Row Height, and then set the width or height to zero.