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
|