| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide "All" in pivot table
I need to hide "All" in the pull down menu of a pivot table. Can I do that? I
don't know if it is called "All" since I am using non english version. For example, in the "Month" field, there were months from Jan to Dec, and you can select "All" for all months consoildation, I need to hide the selection "A'll'. -- Dennis Cheung |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide "All" in pivot table
Hi Dennis
Download the following example form Debra Dalgleish's site http://www.contextures.com/excelfiles.html#Pivot Amend to hide rows 7 & 8 and move cells C2:D2 to B6:C6 -- Regards Roger Govier "Dennis Cheung" wrote in message ... I need to hide "All" in the pull down menu of a pivot table. Can I do that? I don't know if it is called "All" since I am using non english version. For example, in the "Month" field, there were months from Jan to Dec, and you can select "All" for all months consoildation, I need to hide the selection "A'll'. -- Dennis Cheung |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| Hide "Show details" when right click on data field in Pivot Table | Excel Discussion (Misc queries) | |||
| how to hide "All" in drop-down menu of my pivot table | Excel Discussion (Misc queries) | |||
| Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
| how to hide the "(All)" option on a pivot table | Excel Programming | |||
Linear Mode
