Displaying hidden columns or rows
Displaying columns or rows by selecting
- Select the columns on either side of the hidden one(s) or the rows above and below the hidden one(s).
- In the action bar, click Range.
- In the pop-up menu, click Column or Row.
- Click Show hidden column(s) or Show hidden row(s).
Tip The Show hidden column(s) or Show hidden row(s) buttons are active only when there are hidden columns or rows in the selected range. Otherwise, thes button are gray.
Your change takes effect immediately.
- To close the pop-up panel, click
.
Displaying a column or row by dragging
Dragging a column or row border is another way to display a hidden column or row.
- Position the mouse pointer in the worksheet frame on the border of a hidden column or row.
- Drag the border of the hidden column right or drag the border of the hidden row down.
- Release the mouse button.
See also
Why hide data?
Hiding columns or rows
Hiding the worksheet gridlines
Protecting data
Sizing columns
Sizing rows