Custom Views are Re-Setting my Freeze Panes settings

[ebrandt]

I'm setting a custom view that has certain filters set on my data. I'm filtering by 2 columns. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered out of my custom view (ie not showing) becomes a part of the frozen header rows at the top.

Is there a way I can fix this besides re-setting the frozen panes each time I look at a custom view?

Thanks!

 

[6StringJazzer]

Hard to visualize but I would say you need to create another custom view that is the default view (without the filtering), rather than clearing the filtering while you are on this custom view.

 

[ebrandt]

That works! Thanks