Pivot Table - Dragging multiple items into data field
 

I have about 50 columns of data that I want to put into the Data field. The
wizard only allows me to drag one at a time. How would I drag them all in
together?

Pivot Table - Dragging multiple items into data field
 

That's a lot of fields for the data area! I don't know of any way to add
multiple fields to the data area at one time, using the wizard.

On the worksheet, in the PivotTable field list, you can select Data area
from the dropdown at the bottom. Then, double-click on a field in the
list, to add it to the data area.

J@Y wrote:
I have about 50 columns of data that I want to put into the Data field. The
wizard only allows me to drag one at a time. How would I drag them all in
together?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html