Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter changes frozen pane
When I use autofilter with freeze pane to keep the headers visible, the
location of the pane periodically changes. Sometimes when I try to view all rows, a number of them will remain hidden. Is there a way to prevent this problem? It doesn't happen all the time, just seemingly at random. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter changes frozen pane
I bet you filtered to hide some rows, then applied the Freeze pane.
If you show all the rows, then apply the freeze panes directly under the headers, you should be ok. LMBart wrote: When I use autofilter with freeze pane to keep the headers visible, the location of the pane periodically changes. Sometimes when I try to view all rows, a number of them will remain hidden. Is there a way to prevent this problem? It doesn't happen all the time, just seemingly at random. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I choose which lines are frozen using "freeze pane"? | Excel Discussion (Misc queries) | |||
Freeze pane moves when saved with autofilter | Excel Discussion (Misc queries) | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
How do I JUMP from pane 1 to Pane 2? | Excel Worksheet Functions | |||
Frozen Pane Lines | Excel Discussion (Misc queries) |