| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Dragging multiple items into data field
I have about 50 columns of data that I want to put into the Data field. The
wizard only allows me to drag one at a time. How would I drag them all in together? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Dragging multiple items into data field
That's a lot of fields for the data area! I don't know of any way to add
multiple fields to the data area at one time, using the wizard. On the worksheet, in the PivotTable field list, you can select Data area from the dropdown at the bottom. Then, double-click on a field in the list, to add it to the data area. J@Y wrote: I have about 50 columns of data that I want to put into the Data field. The wizard only allows me to drag one at a time. How would I drag them all in together? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and special functions in Pivot table report | Excel Worksheet Functions | |||
| Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
| Orientation of multiple data items in Pivot table | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
Hybrid Mode
