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.
- To hide a column, position the mouse pointer in the worksheet frame on the right border of the column you want to hide.
- To hide a row, position the mouse pointer in the worksheet frame on the bottom border of the row you want to hide.
- Drag the column border left or the row border up until the column or row is hidden.
- Release the mouse button.
Another way to hide columns or rows
You can hide columns and rows using the Range menu.
- Select the column(s) or row(s) you want to hide.
- In the action bar, click Range.
- In the popup menu, click Column or Row.
- Click Hide column(s) or Hide row(s).
Your change takes effect immediately.
- To close the pop-up panel, click
.
See also
Displaying hidden columns or rows
Hiding the worksheet gridlines
Protecting data
Sizing columns
Sizing rows