How do you turn off pivot table auto format in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know how to return to the original/default pivot table format after
I have already applied an auto format report style.
 
In the list of AutoFormats, select PivotTable Classic, which is at the
bottom of the AutoFormat list.
 
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.
 
Apply one of the Table AutoFormats first, e.g. Table 8.
Then apply the PivotTable Classic AutoFormat
You may have to rearrange some of the fields manually, if it doesn't
return to the layout that you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column width of Pivot Table data goes back to default when data refreshed 2
Excel 2003 Pivot Formatting 2
Original Pivot Table Defaul Format 2
Pivot Table Formatting 4
Pivot Table - Changes 5
Pivot Table Formats 2
Pivot Table Refresh 1
Pivot table questions 1

Back
Top