Why does freeze panes work on one sheet but not on another in sam.
 

I have two separate worksheets in one excel workbook. By applying freeze
panes, I am able to lock the column headings on one of the worksheets so they
remain at the top of the page when I scroll down the worksheet. Applying
freeze panes to the other worksheet has no effect. The column headings
scroll off the page when I scroll down the worksheet. Does anyone have a
solution for this problem?

Hi

on the second worksheet, what cell are you selecting when you choose freeze
/ panes?

Cheers
JulieD

"environengineer" wrote in
message ...
I have two separate worksheets in one excel workbook. By applying freeze
panes, I am able to lock the column headings on one of the worksheets so
they
remain at the top of the page when I scroll down the worksheet. Applying
freeze panes to the other worksheet has no effect. The column headings
scroll off the page when I scroll down the worksheet. Does anyone have a
solution for this problem?