Can I Freeze AND Split Pane...

[otrevino3]

with Filtered Data?

I need row 1 to always be visible (column headers).

I also need row 460 (specifically C460) to always be visible (sub total).

The column headers are also filters.

I've tried to freeze and split simultaneously, but it seems that you can't do both (at least not with filters applied).

thx

 

[watkins6878]

Could you not just copy row 460 (c460) to row 2 then freeze lines 1 & 2

 

[otrevino3]

I ended up putting the subtotal in the column header (the filters would filter it out otherwise), and freezing the pane below row 1.

I could kick you for providing such a simple answer.

Instead, I'll say thanks and kick myself instead.