How do I add multiple variables to a pivot table simulaneously
If you need to do it a lot, either set up a template, with the pivot table defined, and then copy
the new data over your old data table, or record a macro.
HTH,
Bernie
MS Excel MVP
"Sreejith" wrote in message
...
Is that the only way to do it. I have to routinely add 100 or so variables.
"Bernie Deitrick" wrote:
Dragging one by one is how it is done, or write a macro that does it for you.
HTH,
Bernie
MS Excel MVP
"Sreejith" wrote in message
...
I want to add some columns to the pivot table. i do this by dragging the
items to the data area. How can I add many items at the same time instead of
dragging them one by one.
|