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.