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.
--
ERR229

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

I forgot to mention, this is in Excel 2000 (it's easy in 2003!)
--
ERR229


"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.
--
ERR229

Yes, I'm trying to clear the checkboxes (in 2000). I was hoping there was a
keyboard shortcut or something else that I had yet to discover. Alas, it
looks as though it's a manual process.

Thanks for the response.
--
ERR229


"Debra Dalgleish" wrote:

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