Microsoft Office Tutorials and References
In Depth Information
Hide Columns and Rows
Chapter 3: Customizing Worksheet Presentation
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 Ctrl+0.
2
3
1
5
4
Excel removes the
column from the
worksheet display.
Excel displays a slightly
thicker header 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 pointer over the
right edge of the column
header and then click
and drag the edge to the
left. Excel displays a
banner that shows the
current width; when that
banner displays the width
as 0, release the mouse
button.
Reverse It!
To display a hidden row, select the row above and the row below the hidden row, click
the Home tab, click the Format drop-down arrow, click Hide & Unhide, and then click
Unhide Rows. Alternatively, move the mouse pointer between the headers of the
selected rows and then double-click. 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 the Home tab, click the Format drop-down arrow, click Hide &
Unhide, and then click Unhide Columns. Alternatively, move the mouse pointer between
the headers of the selected rows and then double-click. To unhide column A, right-click
the left edge of the column B header and then click Unhide.
 
Search JabSto ::




Custom Search