View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default 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