Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fields names do not show in excel 2007 pivot table fields list marlo17 New Users to Excel 2 December 1st 08 01:25 PM
copy field settings of a field to other fields in same pivot tbl new22007 Excel Worksheet Functions 0 May 8th 08 10:22 PM
Drag multiple fields into data of pivot table maplesugarsnow Excel Worksheet Functions 0 July 18th 07 04:18 PM
pivot field of fields BorisS Excel Worksheet Functions 0 June 15th 05 04:43 PM
I cannot drag a Pivot Table field into the page area KimboR Excel Discussion (Misc queries) 2 February 23rd 05 02:29 PM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"