Hiding columns or rows

Dragging a column or row border is a quick direct way to hide columns or rows. Why hide data? provides basic information about hiding columns and rows of data in the worksheet.

  1. To hide a column, position the mouse pointer in the worksheet frame on the right border of the column you want to hide.

    Hiding a column by dragging

  2. To hide a row, position the mouse pointer in the worksheet frame on the bottom border of the row you want to hide.

    Hiding a row by dragging

  3. Drag the column border left or the row border up until the column or row is hidden.

  4. Release the mouse button.



Another way to hide columns or rows

You can hide columns and rows using the Range menu.

  1. Select the column(s) or row(s) you want to hide.

  2. In the action bar, click Range.

  3. In the popup menu, click Column or Row.

  4. Click Hide column(s) or Hide row(s).

    Your change takes effect immediately.

  5. To close the pop-up panel, click Pop-up panel close button.



See also
Displaying hidden columns or rows
Hiding the worksheet gridlines
Protecting data
Sizing columns
Sizing rows