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