In pivot table, data column. I would like to show several columns of data.
Please instruct me how to do it?

To arrange the data fields horizontally, drag the Data field button onto
the cell that contains the word Total, as shown he

http://www.contextures.com/xlPivot02.html

Linda wrote:
In pivot table, data column. I would like to show several columns of data.
Please instruct me how to do it?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! Thanks for letting me know that you like it.

Granny 3.1 wrote:
I was playing around on your website and it was created by you...nice
job....I'm going to put it on the list I give my students as handy sites to
answer questions about Office Suites. I wish I could teach out of your book
they would probably get more out of the class. Nice work...Thanks again


"Debra Dalgleish" wrote:


To arrange the data fields horizontally, drag the Data field button onto
the cell that contains the word Total, as shown he

http://www.contextures.com/xlPivot02.html

Linda wrote:

In pivot table, data column. I would like to show several columns of data.
Please instruct me how to do it?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I'm sure you've inspired many students to continue learning on their
own, and glad the information on my site has helped. Jon Peltier has a
list of Excel resources that may also help your class:

http://www.peltiertech.com/Excel/excellinks.html

and there are other Office links he

http://www.mvps.org/#app

Granny 3.1 wrote:
You're very welcome...praise should be given when it is so richly deserved.
Still wish I had a say in what books we teach out of. I'd have to choose
yours. I gave the class the shortcut and all the sudden they understand what
a pivot table is and why someone would use it. Kind of a hard point to get
across to such a short timed class. Only get 16 days in Excel, hardly enough
time to brush on the subject. But with your site they actually
understand...they all say thanks to you by the way. I gave them extra credit
to go to your site and make a pivot table...they all did very well.


"Debra Dalgleish" wrote:


You're welcome! Thanks for letting me know that you like it.

Granny 3.1 wrote:

I was playing around on your website and it was created by you...nice
job....I'm going to put it on the list I give my students as handy sites to
answer questions about Office Suites. I wish I could teach out of your book
they would probably get more out of the class. Nice work...Thanks again


"Debra Dalgleish" wrote:



To arrange the data fields horizontally, drag the Data field button onto
the cell that contains the word Total, as shown he

http://www.contextures.com/xlPivot02.html

Linda wrote:


In pivot table, data column. I would like to show several columns of data.
Please instruct me how to do it?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html