| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag multiple fields into data of pivot table
Hi,
I have a pivot table where I need to drag 30+ fields into the data area. I have not found anyway to select more than one at a time to drag over. Double clicking them puts them in the row fields not the data area. Any help would be grat appreciate sinc eI have to do this quarterly. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple fields to a Pivot table at one time | Excel Discussion (Misc queries) | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
| drag multiple data items into pivot | Excel Worksheet Functions | |||
| Pivot Table with Multiple Row Fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
