Microsoft Office Tutorials and References
In Depth Information
Hiding rows and columns
Hiding rows and columns
In some cases, you may want to hide particular rows or columns. Hiding rows and columns
may be useful if you don’t want users to see particular information, or if you need to print
a report that summarizes the information in the worksheet without showing all the details.
To hide rows in your worksheet, select the row or rows that you want to hide by clicking
in the row header on the left. Then right-click and choose Hide from the shortcut menu. Or
you can use the commands on the Home ➪ Cells ➪ Format ➪ Hide & Unhide drop-down list.
To hide columns, use the same technique, but start by selecting columns rather than rows.
You can also drag the row or column’s border to hide the row or column. You must drag the border in the row or
column heading. Drag the bottom border of a row upward or the border of a column to the left.
A hidden row is actually a row with its height set to zero. Similarly, a hidden column has a
column width of zero. When you use the navigation keys to move the cell pointer, cells in
hidden rows or columns are skipped. In other words, you can’t use the navigation keys to
move to a cell in a hidden row or column.
Notice, however, that Excel displays a very narrow column heading for hidden columns and
a very narrow row heading for hidden rows. You can drag the column heading to make the
column wider — and make it visible again. For a hidden row, drag the small row heading to
make the column visible.
Another way to unhide a row or column is to choose Home ➪ Editing ➪ Find & Select ➪ Go
To (or its F5 equivalent) to select a cell in a hidden row or column. For example, if column
A is hidden, you can press F5 and specify cell A1 (or any other cell in column A) to move
the cell pointer to the hidden column. Then you can choose Home
Unhide ➪ Unhide Columns.
Changing column widths and row heights
Often, you’fill want to change the width of a column or the height of a row. For example, you
can make columns narrower to show more information on a printed page. Or you may want
to increase row height to create a “double-spaced” effect. Excel provides several different
ways to change the widths of columns and the height of rows.
Changing column widths
Column width is measured in terms of the number of characters of a monospaced font that
will ﬁ t into the cell’s width. By default, each column’s width is 8.43 units, which equates to
64 pixels (px).