Autofilter changes frozen pane

  • Thread starter Thread starter LMBart
  • Start date Start date
L

LMBart

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze pane moves when saved with autofilter 4
How to keep Column headers with Autofilter & Freeze Panes 8
Frozen panes in Excel should stay put when using autofilter. 8
Placement of autofilter drop down menu? 6
Freeze Panes bug when grouping columns and sharing a workbook 1
Sorting issue with frozen panes 11
Excel loses "Freeze Panes" setting 1
Freeze panes problems in shared workbook 2

Back
Top