![]() |
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 |
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 |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com