View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Josh Johansen Josh Johansen is offline
external usenet poster
 
Posts: 72
Default Pivot Table Field Reordering

I tried this, and I have the manual option selected, but the top 10 autoshow
is greyed out and I am unable to do any draging of any kind. I cannot figure
out what is stopping me from reordering the list.

"Ed Ferrero" wrote:

Hi Josh,

I would like to be able to manually reorder the field selections that I see
when selecting a drop down box in a pivot table but I am unable to figure
out
how to do this. Thanks.


Drag the page field (drop down box) to either a column or row field. Then
drag items to manually reorder the list. Then drag back to a page field.

Ed Ferrero
www.edferrero.com