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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

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,656
Messages
5,573,428
Members
412,529
Latest member
cTatch
Top