Thread: Pivot Tables
View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Are you trying to clear all the check boxes in the field's dropdown
list? In Excel 2002 and later versions, there's a Show All checkbox. In
Excel 2000, and earlier versions, you can use programming to hide or
show the items -- there's sample code he

http://www.contextures.com/xlPivot03.html

ERR229 wrote:
Does anyone know if there is a way to quickly clear a field list? I can't
find a keyboard shortcut or anything else in any of the help/support avenues
I've tried.

Thanks in advance for the help.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html