Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

Excel 2000 Pivot Table - dropdown lists

Posted by Paul on November 19, 2001 11:47 AM

I am now using Excel 2000. Can anyone tell me how to either select or deselect all in the ROW field dropdowns?

Thanks!

Re: Excel 2000 Pivot Table - dropdown lists

Posted by Mark W. on November 19, 2001 11:50 AM

There isn't a drop down list for either the ROW
or COLUMN fields -- just the PAGE field. What
is it you're trying to "select or deselect"?

Re: Excel 2000 Pivot Table - dropdown lists

Posted by Paul on November 19, 2001 11:56 AM

In Excel 2000, there are dropdowns on the ROW fields that allow you to hide unrequired row data. It's these lists that I want to be able to select all.

I stand corrected...

Posted by Mark W. on November 19, 2001 12:15 PM

I forgot that Microsoft did that! They merely
changed the GUI, but didn't add any functionality.
There wasn't a method to Hide/Show all in Excel 97
either.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.