PivotTable Field List Dialog Box in Excel 2007

Pivot Table Field List Dialog Box


Pivot table is the most amazing feature of Excel. We can use pivot table in Excel on daily basis to create & analyze what the data is all about. With Pivot table drag & drop feature, we can try various ways to summarize report. In this article, we will focus on how to hide & unhide field list box in order to save the screen space when not in use.

Following is the snapshot of data we have:




To hide or unhide the Field list, first we have to make pivot table & following is the snapshot of pivot table we have:




We need to follow the below steps to hide/unhide the Field list in pivot table.

  • Click on Analyze ribbon
  • In Show group, click on Field list to hide/unhide
  • Following is the snapshot of pivot report




  • After we click on Field list, the pivot table field list will not be available for display.




In above snapshot, you will find the pivot table field list will not be there because the Field list option under Analyze ribbon is not activated.

In this way, user can play with available screen area to show some other important stuff like chart or so.


image 48




If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.