Microsoft Office Tutorials and References
In Depth Information
Hiding and unhiding columns and rows
Unhide rows or columns
1 Click the row or column header of the row above or the column to
the left of the rows or columns you want to unhide.
2 Hold down the Shift key, and click the row or column header of the
row below or the column to the right of the rows or columns you
want to unhide.
3 Right-click the selection, and choose Unhide from the shortcut
TIP There are two ways that you can tell that hidden rows or
columns are in a worksheet. First, whenever rows or columns
are hidden, row numbers or column letters are missing. For example, if
rows 2, 3, and 4 are hidden, the first two visible rows of the worksheet
are labeled row 1 and row 5. The other way you can tell that a
worksheet contains hidden rows or columns is by the thick line that appears
on the border of the row header or column header where the rows or
columns would otherwise appear.