View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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