![]() |
Returning to multiple data fields pivot table view
Hi,
My pivot table contains a "Data" column consisting of several DATA fields. When I want to view only one of the fields, I use the down-arrow of the Data column header, deselect the undesired fields and keep the desired one selected. When I confirm, Excel disposes the Data column and shows the selected field at a different location on the pivot table. Now, when I want to view all fields again, I have to redefine them and their settings all over again. Is there a way to keep the Data column in place, even when only one field is currently selected? Thanks. |
All times are GMT +1. The time now is 01:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com