Custom Views are Re-Setting my Freeze Panes settings

ebrandt

Board Regular
Joined
Dec 13, 2010
Messages
51
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!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

6StringJazzer

Well-known Member
Joined
Jan 27, 2010
Messages
700
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,764
Messages
5,574,104
Members
412,569
Latest member
kiteifitswindy
Top