| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables hide info drop down menu
I have a pivot table and I need to hide data on the worksheet. When I access
the drop down menu, all of the categories do not appear on the list. How do I get all items to appear in the drop down menu? What causes this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot tables hide info drop down menu
If this is a field in the page area, some items may be hidden.
Right-click on the field button, and choose Field Settings In the Hide Items list, click on any selected items, to unselect them. Click OK JSM wrote: I have a pivot table and I need to hide data on the worksheet. When I access the drop down menu, all of the categories do not appear on the list. How do I get all items to appear in the drop down menu? What causes this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
| Help with drop down menu | Excel Worksheet Functions | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| link drop down menu to info in worksheet | New Users to Excel | |||
Linear Mode
