Microsoft Office Tutorials and References
In Depth Information
Getting a Better Look at the Worksheet
your screen). You can tell where split bars are because the pointer
turns into a double arrow when it’s over a split bar.
• Freezing: Click the Freeze Panes button and choose one of three
Freeze options on the drop-down list. The second and third options,
respectively, freeze the top row or first column. The first option,
Freeze Panes, freezes the column(s) to the left and the row(s) above
the cell you selected in Step 1.
Bars or lines appear on-screen to show which row(s) and column(s)
have been frozen or split. Move where you will in the worksheet. The
column(s) and row(s) you froze or split stay on-screen.
Unsplitting and unfreezing
Use one of these techniques to keep your worksheet from splitting or
freezing to death:
✦ Unsplitting: Click the Split button again; double-click one of the split
bars to remove it; or drag a split bar into the top or left side of the
✦ Unfreezing: On the View tab, click the Freeze Panes button and choose
Unfreeze Panes on the drop-down list.
Hiding columns and rows
Another way to take the clutter out of a worksheet is to temporarily hide
columns and rows:
✦ Hiding columns or rows: Drag over the column letters or row numbers
of the columns or rows that you want to hide. Dragging this way selects
entire columns or rows. Then go to the Home tab, click the Format
button, choose Hide & Unhide, and choose Hide Columns or Hide Rows.
✦ Unhiding columns and rows: Select columns to the right and left of the
hidden columns, or select rows above and below the hidden rows. To
select columns or rows, drag over their letters or numbers. Then go
to the Home tab, click the Format button, choose Hide & Unhide, and
choose Unhide Columns or Unhide Rows.
It’s easy to forget where you hid columns or rows. To make sure all columns
and rows in your worksheet are displayed, click the Select All button (or
press Ctrl+A) to select your entire worksheet. Then go to the Home tab, click
the Format button and choose Hide & Unhide ➪ Unhide Columns; click the
Format button again and choose Hide & Unhide ➪ Unhide Rows.