| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a pivot table from multiple pages of data? | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
