Microsoft Office Tutorials and References
In Depth Information
Hide a Row or Column
Hide a Row
or Column
If you do not need to see or work with a row or
column temporarily, you can make your worksheet
easier to read and to navigate by hiding the row or
column. Hiding a row or column is also useful if you
are showing someone a worksheet that contains
private or sensitive data that you do not want the
person to see.
Hiding a row or column does not affect other parts of
your worksheet. In particular, formulas that use or
rely on data in the hidden rows and columns still
display the same results.
Hide a Row or Column
Hide a Row
1 Click in any cell in the row
you want to hide.
2 Click the Home tab.
3 Click Format .
4 Click Hide & Unhide .
5 Click Hide Rows .
Note: You can also hide a
row by pressing
+
.
A Excel removes the row from
the worksheet display.
B Excel displays a double-line
heading border between
the surrounding rows to
indicate that a hidden row
lies between them.
Another way to hide a row
is to move the mouse
over the bottom edge of
the row heading (
changes to ), and then
click and drag the edge up
until the height displays 0.
Search JabSto ::




Custom Search