Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freezed panes and autofilter
Hi,
I am working with a protected shared workbook (only one sheet) where the first row is locked, in a freezed pane to stay visible, with the Autofilter turned on. I have freezed the panes with the Autofilter showing all the lines and before protecting the workbook. I am running Excel 2003. My problem is that, from time to time, when I open the file, the top pane includes a few rows and not only the first one. In some case, I even have to unfreeze the panes because the top pane is bigger than the screen. I move back the handle to the first row and freeze the panes again to have it right. This is quite annoying. Why the top pane keeps expanding ? I feel it is related to the Autofilter but I don't see how... Thanks for your answer, Best regards, Laurent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) |