MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table headers are missing pick arrows

Posted by Loren on January 18, 2001 7:28 AM

Made a new pivot table but all headers are missing pick arrows.
What happened? thx

Posted by Mark W. on January 18, 2001 7:33 AM

What's a pick arrow? Are you confusing a PivotTable
with an Autofiltered list?

Posted by Dave Hawley on January 18, 2001 6:50 PM

Hi Loren

Pivot Table headers will only have "pick arrows" (filters) if they are in the Page field position. Click and drag your heading up to the very top of the Pivot Table until they change to a step shape then release.

DaveOzGrid Business Applications