sorting data in pivot table field drop downs
 

When selecting data to be displayed in a pivot table field, I find it
difficult to locate all the data I want to select as the data in the drop
down is not in sequential order. Is there a way to sort this data to
facilitate selection?

sorting data in pivot table field drop downs
 

Duplicate post (problem with MS newsreader), see other thread:
http://www.microsoft.com/office/comm...6-7018f9f991e9
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steve 51" wrote:

When selecting data to be displayed in a pivot table field, I find it
difficult to locate all the data I want to select as the data in the drop
down is not in sequential order. Is there a way to sort this data to
facilitate selection?

sorting data in pivot table field drop downs
 

Check out this link...
http://www.contextures.com/xlPivot04.html
--
HTH...

Jim Thomlinson


"Steve 51" wrote:

When selecting data to be displayed in a pivot table field, I find it
difficult to locate all the data I want to select as the data in the drop
down is not in sequential order. Is there a way to sort this data to
facilitate selection?