View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
srudd
 
Posts: n/a
Default How do you turn off pivot table auto format in Excel?

I have tried this and it does not get me back to the original format. I want
to return to the format with the data elements listed in row mode instead of
across columns.

"Debra Dalgleish" wrote:

In the list of AutoFormats, select PivotTable Classic, which is at the
bottom of the AutoFormat list.

srudd wrote:
I want to know how to return to the original/default pivot table format after
I have already applied an auto format report style.



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