Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table - untick all items in row field
Can you please tell me if it is possible in Excel 2000 to uncheck or de-select all items in the row field. The reason being is that when a row field has 100s of items and you only want to select a few of these items - it is very time consuming to manually go through and uncheck all the ones that you don't want. Excel by default has them all checked/ticked - and I would like to be able to unchceck or de-select them all and then just select the one or two that I want. Is that possible? -- DD1 ------------------------------------------------------------------------ DD1's Profile: http://www.excelforum.com/member.php...o&userid=25169 View this thread: http://www.excelforum.com/showthread...hreadid=386665 |
#2
|
|||
|
|||
In Excel 2000, and earlier versions, the Show All checkbox isn't
available. You can use a macro to hide or show the items -- there's sample code on my web site: http://www.contextures.com/xlPivot03.html DD1 wrote: Can you please tell me if it is possible in Excel 2000 to uncheck or de-select all items in the row field. The reason being is that when a row field has 100s of items and you only want to select a few of these items - it is very time consuming to manually go through and uncheck all the ones that you don't want. Excel by default has them all checked/ticked - and I would like to be able to unchceck or de-select them all and then just select the one or two that I want. Is that possible? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Just uncheck the top check box called "(show all)" and all items will be
unchecked. Gary "DD1" wrote: Can you please tell me if it is possible in Excel 2000 to uncheck or de-select all items in the row field. The reason being is that when a row field has 100s of items and you only want to select a few of these items - it is very time consuming to manually go through and uncheck all the ones that you don't want. Excel by default has them all checked/ticked - and I would like to be able to unchceck or de-select them all and then just select the one or two that I want. Is that possible? -- DD1 ------------------------------------------------------------------------ DD1's Profile: http://www.excelforum.com/member.php...o&userid=25169 View this thread: http://www.excelforum.com/showthread...hreadid=386665 |
#4
|
|||
|
|||
My apologies, I didn't catch the Excel 2000 reference.
Gary "Debra Dalgleish" wrote: In Excel 2000, and earlier versions, the Show All checkbox isn't available. You can use a macro to hide or show the items -- there's sample code on my web site: http://www.contextures.com/xlPivot03.html DD1 wrote: Can you please tell me if it is possible in Excel 2000 to uncheck or de-select all items in the row field. The reason being is that when a row field has 100s of items and you only want to select a few of these items - it is very time consuming to manually go through and uncheck all the ones that you don't want. Excel by default has them all checked/ticked - and I would like to be able to unchceck or de-select them all and then just select the one or two that I want. Is that possible? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Many thanks for answering that so quickly Debra. I really appreciate your help. -- DD1 ------------------------------------------------------------------------ DD1's Profile: http://www.excelforum.com/member.php...o&userid=25169 View this thread: http://www.excelforum.com/showthread...hreadid=386665 |
#6
|
|||
|
|||
You're welcome! If you aren't familiar with using programming, there are
instructions here for copying the code to your workbook: http://www.contextures.com/xlvba01.html and David McRitchie has instructions for getting started with macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm DD1 wrote: Many thanks for answering that so quickly Debra. I really appreciate your help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - untick all items in row field
I am having the same trouble. I copied the code in to the workbook, but how do you use it? -- rmm30 ------------------------------------------------------------------------ rmm30's Profile: http://www.excelforum.com/member.php...fo&userid=8358 View this thread: http://www.excelforum.com/showthread...hreadid=386665 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
caluclated field in pivot table? | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |