Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data Filter Pane
Hey....dumb question (I fear): When working with a pivot table/chart in
excel 2007, a "floating" pane appears when I click on the chart of the table, and I "think" it is called Pivot Data Filter Pane or somesuch. I cannot say for sure, as it is somewhat of an irritant and in the way, most of the time, so I close it. But now, I want to open it, and cannot find out how to do it. There is no verbiage about it in the help. It is like it does not exist. Can anyone tell me how, once it has been closed, to bring up this filter pane, again? Thanks! Patk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Data Filter Pane
Not sure, are you talking about the Field List? If so, click on the pivot
table, and under "PivotTable Tools" on the toolbar, click on "Options". From there, on the far right side of the toolbar, select "Field List". Laura "PatK" wrote in message ... Hey....dumb question (I fear): When working with a pivot table/chart in excel 2007, a "floating" pane appears when I click on the chart of the table, and I "think" it is called Pivot Data Filter Pane or somesuch. I cannot say for sure, as it is somewhat of an irritant and in the way, most of the time, so I close it. But now, I want to open it, and cannot find out how to do it. There is no verbiage about it in the help. It is like it does not exist. Can anyone tell me how, once it has been closed, to bring up this filter pane, again? Thanks! Patk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table data filter | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter | Excel Discussion (Misc queries) | |||
auto filter data within pivot table | Excel Discussion (Misc queries) | |||
Can I set a filter on the source data for a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) |