Drag multiple fields into data of pivot table
 

Hi,

I have a pivot table where I need to drag 30+ fields into the data area. I
have not found anyway to select more than one at a time to drag over. Double
clicking them puts them in the row fields not the data area. Any help would
be grat appreciate sinc eI have to do this quarterly.

Thanks.