Prev: Splitting Equals
Next: Password Protecting a workbook
From: Jen_T on 14 Apr 2010 08:02
I was wondering if there is an easy way to locate a specific field in the
pivot field list in Excel 2007 without having to scroll the list of fields
and find the one you are looking for if you have many? I know in 2003 you
were able to start typeing the word or numeric and it would find the first
match as you typed.
From: Herbert Seidenberg on 15 Apr 2010 13:04
Excel 2007 PivotTable
Expanded, auto-complete
PivotItem drop-down list in RowField.
With macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_14_10.xlsm
Pdf preview:
http://www.mediafire.com/file/mewgzmiwzyd/04_14_10.pdf

 | 
Pages: 1
Prev: Splitting Equals
Next: Password Protecting a workbook