Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Autoformat in pivot tables
Does anyone know if it is possible to remove an autoformat from a pivot table
once the document is saved? I would like to return the pivot table to its original form before the autoformat. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Autoformat in pivot tables
Select a cell in the pivot table, and choose FormatAutoFormat
Scroll to the bottom of the list of AutoFormats, and click on PivotTable Classic Click OK If you had previously applied one of the Report AutoFormats, e.g. Report4, any column headings would have been automatically moved to the Row area. You'll have to manually move those fields back to the Column area. C Tate wrote: Does anyone know if it is possible to remove an autoformat from a pivot table once the document is saved? I would like to return the pivot table to its original form before the autoformat. Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Can I "customize" an autoformat report for a Pivot Table in Excel | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |