Drag multiple fields into data of pivot table

M

maplesugarsnow

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Embed the same Excel multiple times 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data Aggregation 0
STDEV in a Formula for Calculated Field in Pivot Table 0
print area Excel 2007 0
Pivot table grouping help 0
Pivot Tables by Macro 2

Top