Freezing Panes

graphics/microsoft3.gif

Once you've finished creating the worksheet structure ”labels and formulas ”you're ready to enter data. The first six columns and twelve rows or so are just fine, but as you scroll to enter data in later columns or rows, the labels for the column headings shift out of view. Instead of memorizing the headings, freeze the label columns and rows so they remain visible as you scroll through the rest of the worksheet. You can freeze a row, a column, or a pane from a split worksheet.

Freeze Columns and Rows

graphics/one_icon.jpg Click the cell that intersects the rows and columns you want to remain visible on the screen.

To freeze panes from a split window, skip step 1.

graphics/two_icon.jpg

Click the Window menu, and then click Freeze Panes.

graphics/three_icon.jpg

Edit and scroll the worksheet as usual.

graphics/07inf39.jpg

Unfreeze Columns and Rows

graphics/one_icon.jpg

Click the worksheet that you want to unfreeze.

graphics/two_icon.jpg

Click the Window menu, and then click Unfreeze Panes.

graphics/07inf40.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net