Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I apologise if this has been asked before, but Could someone please advise
me how to remove items from within a pivot table The first box of my pivot table has a pull down arrow which if I click on, it shows all the info it has found. at the top of the info there is a box which says "Show all" Beside each individual entry there is a tick box which results in the info either being used by the table (if ticked) or ignored by the table (if left clear) After several months of use there are now lots of these items which I will never refer to again and I would dearly love to delete them from the pivot table without having to delete anything from the sheet that the pivot table has collected the data from. I know that I can just leave the tick boxes clear and the data will get ignored by the pivot table, but apart from anything else, it looks untidy Is there a fix? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |