Thread
:
Pivot table format question
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary Brown
external usenet poster
Posts: 178
Pivot table format question
Grab the data field you want as a column by left-clicking on it and dragging
it to the column area and dropping it.
--
HTH,
Gary Brown
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.
" wrote:
When I create a pivot table, with multiple data fields, the data
fields, by default, show up as different rows. I prefer to have a
different column for each data field, and I can get the data into
columns by selecting any of several of the default report format.
However, I don't really care to get all the formatting that comes with
the available formats. How can I get my pivot tables to display data
fields in separate columns without first picking a default Pivot Table
format?
Thanks
Ken
Reply With Quote
Gary Brown
View Public Profile
Find all posts by Gary Brown