ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to browse Pviot Field List in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/177922-how-browse-pviot-field-list-excel-2007-a.html)

Craig Graham[_2_]

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


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com