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 |
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) |