In my pivot table when I select one of my drop down arrows, I see that
every choice under it is already selected. There is no deselect or
select all option so I have to scroll down and manually hit space bar
to deselect all and then go back and select the one or two that I want.
Is there a way to do this using keyboard shortcuts or a way to get the
deselect/select all option in the drop down arrow? Thanks.


--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=538115

Debra Dalgleish has an addin that you may like:
http://contextures.com/xlPivotAddIn02.html

And if you want to build your own code, she has plenty of samples:
http://contextures.com/xlPivot03.html

jpx wrote:

In my pivot table when I select one of my drop down arrows, I see that
every choice under it is already selected. There is no deselect or
select all option so I have to scroll down and manually hit space bar
to deselect all and then go back and select the one or two that I want.
Is there a way to do this using keyboard shortcuts or a way to get the
deselect/select all option in the drop down arrow? Thanks.

--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=538115

--

Dave Peterson