Pivot ... Drag Multiple Fields from Field List?

  • Thread starter Thread starter Ken
  • Start date Start date
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
 
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
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Different ways to build Pivot table 1
how to drag multiple items to pivot table report at once 0

Back
Top