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?