drag multiple data items into pivot
I have 100+ unique data items that I need to drag into the data field in my
pivot table every quarter. Is there some way to select multiple data items out of the pivot table field list so I do not have to drag/drop 100+ times? I tried shift and/or ctlr to select multiple to drage but it does not work. I can really use a timesaver for this one! Thanks. |
All times are GMT +1. The time now is 12:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com