ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   drag multiple data items into pivot (https://www.excelbanter.com/excel-worksheet-functions/51961-drag-multiple-data-items-into-pivot.html)

maplesugarsnow

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