Pivot Table Column Header

[meetdudhia]

How one can make pivot table header dynamic, meaning it drags down when one scrolls down. I have like 3000 lines of data so when I scroll down my column header are not coming down.

Please help on that, Excel 2010.

Thank you.

 

[Jerry Sullivan]

Since you haven't any responses from someone with xl2010, I'll offer a suggestion based on xl2007.

Use View > Freeze Panes to keep your header at the top.
This works the same with Pivot Tables as it does with standard ranges.