Pivot ... Drag Multiple Fields from Field List?

K

Ken

Excel2003 ... I wish to setup a Pivot which has Several Orders.

Is it possible to drag ALL Orders from the Pivot Table Field List to the
"Drop Data Items Here" section of the Pivot ... or ... most I drag 1 @ a time?

Thanks ... Kha
 
D

Debra Dalgleish

Ken, you'll have to drag them one at a time, or write a macro to add the
fields.
 

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

Pivot (Data Items "Count" vs "Sum") 2
Pivot Table ... Suppress "0" Values? 2
Pivot Table Refresh? 2
Pivot Table Chart? 4
Pivot Chart Bar Chart? 1
how to drag multiple items to pivot table report at once 0
Different ways to build Pivot table 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1

Top