Microsoft Office Tutorials and References
In Depth Information
That’s all there is to it — column B goes poof! All the information in the
column disappears from the worksheet. When you hide column B, notice that
the row of column letters in the frame now reads A, C, D, E, F, and so forth.
You could just as well have hidden column B by right-clicking its column
letter on the frame and then choosing the Hide command on the column’s
Now, suppose that you’ve printed the worksheet and need to make a change
to one of the entries in column B. To unhide the column, follow these steps:
1. Position the mouse pointer on column letter A in the frame and drag
the pointer right to select both columns A and C.
You must drag from A to C to include hidden column B as part of the
column selection — don’t click while holding down the Ctrl key or you
won’t get B.
2. Click the drop-down button attached to the Format button in the Cells
group on the Home tab.
3. Click Hide & Unhide ➪ Unhide Columns on the drop-down menu.
Excel brings back the hidden B column, and all three columns (A, B, and C)
are selected. You can then click the mouse pointer on any cell in the
worksheet to deselect the columns.
You could also unhide column B by selecting columns A through C,
rightclicking either one of them, and then choosing the Unhide command on the
column shortcut menu.
Hiding worksheet rows
The procedure for hiding and unhiding rows of the worksheet is essentially
the same as for hiding and unhiding columns. The only difference is that
after selecting the rows to hide, you click Hide & Unhide ➪ Hide Rows on the
Format button’s drop-down menu and Hide & Unhide ➪ Unhide Rows to bring
Don’t forget that you can use the Hide and Unhide options on the rows’
shortcut menu to make selected rows disappear and then reappear in the worksheet.