View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Marion Löwe Marion Löwe is offline
external usenet poster
 
Posts: 3
Default Sorting Pivot Field List

Hi Craig,
"Craig Graham" wrote:
I have some very large excel pivot tables that I use regularly. How can I
sort the field list into a fashion that makes sense to me?

I would like to sort the list alphabetically is there a way?

I think your column in PT is not the first column.
Excel sort at first the 1.column of the PT, next is the 2.column, but it
sort for the entry in the first line of 1.column, than the next belonging of
the entries in the first column ...
If you wish to sort a special field, try to organise your PT, so that this
field in the PT ist in the left side of the PT.

regards
Marion


Also in excel 2003 you could browse through this list by pushing the letter
e.g. "r' to browse through all fields starting with "r". does this
functionality still exist in 2007?