View Single Post
  #2  
Old November 12th, 2009, 06:50 AM posted to microsoft.public.excel.misc
Debra Dalgleish
external usenet poster
 
Posts: 1,998
Default Pivot ... Drag Multiple Fields from Field List?

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

Ken wrote:
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



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