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.
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.
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 firstname.lastname@example.org
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.