Microsoft Office Tutorials and References
In Depth Information
Hide a Row or Column
3
chapter
Working with Ranges
Hide a Column
1
Click in any cell in the column
you want to hide.
2
Click the
Home
tab.
3
Click
Format
.
4
Click
Hide & Unhide
.
5
Click
Hide Columns
.
Note:
You can also hide a column
by pressing
+
.
C
Excel removes the column from
the worksheet display.
D
Excel displays a slightly thicker
heading border between the
surrounding columns to indicate
that a hidden column lies
between them.
Another way to hide a column is
to move the mouse over the
right edge of the column
heading ( changes to ),
and then click and drag the edge
left until the width displays 0.
How do I display a hidden row or column?
To display a hidden row, select the row above and the row below the hidden row, click
Home
,
click
Format
, click
Hide & Unhide
, and then click
Unhide Rows
. To unhide row 1, right-click
the top edge of the row 2 header, and then click
Unhide
.
To display a hidden column, select the column to the left and the column to the right of the
hidden column, click
Home
, click
Format
, click
Hide & Unhide
, and then click
Unhide
Columns
. To unhide column A, right-click the left edge of the column B header, and then click
Unhide
.
