Piviot Table Set up

  • Thread starter Thread starter les
  • Start date Start date
L

les

I am currently Using Excel 2003.
When Creating a pivot table, in the layout section I have to drag one field
at a time to get what I need. Is there some sort of short cut that would
enable me to grab all the fields at once instead of dragging one at a time.
Thanks.
 
If you're always creating the pivottable based on the same data layout, you
could record a macro when you do it manually.

Then when you need the pivottable recreated, you could run your macro.
 
Back
Top