Wednesday, January 05, 2005

Freeze Panes for view and Repeat descriptive row/col headings for printing

Freeze Panes for view and Repeat descriptive row/col headings for printing: "To see both the column descriptions and the row descriptions, choose the column and cell beyond those you want to freeze.
Select cell B2 --> Window --> Freeze panes

To freeze only the first row descriptions, you would select Row 2 as one beyond the first row the Freeze panes.

To freeze the first two column descriptions, you would select Column C as one beyond the second column and then Freeze panes.

Split and Freeze panes are mutually exclusive you can only have one or the other. Split would allow you to view and scroll independently a vertical and or horizontal split. An alternative to split is to create a new window within Excel to view the same data"

No comments: