View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig Graham[_2_] Craig Graham[_2_] is offline
external usenet poster
 
Posts: 2
Default How to browse Pviot Field List in Excel 2007

I have a very large pivot table database that has 350 fields. In Excel
2003, I could open the field list, click on any item and then depress a
"letter" on the keyboard such as "m" and the list would scroll through all
fields begining with the letter "m" until I found the one I was looking for.
This appears not to work in Excel 2007. Am I missing something? Does anyone
have a suggestion? The fields are grouped in the order that they were added
to the pivot table and as such most are in order but some are not. I would be
receptive to a way to sort all pivot fields either into groups or into
alphabetical order.

Thanks in advance,

Craig