ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot ... Drag Multiple Fields from Field List? (https://www.excelbanter.com/excel-discussion-misc-queries/248107-pivot-drag-multiple-fields-field-list.html)

Ken

Pivot ... Drag Multiple Fields from Field List?
 
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

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



All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com