Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain Format of Pivot Table
I have a Pivot Table, when I refresh the table a certain column changes it
format so that the alignment of the data is no longer centered (i.e. some data is aligned left, some aligned right, etc). I have 'Preserve Format' clicked. Also, in the data table that feeds the pivot table the specific data is 'aligned center'.... Any ideas how I can maintain a format? Cash |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain Format of Pivot Table
Select all the sheet (Control-A and make sure it didn't select just the pivot
table's cells). Go to Format-Cells, Alignment tab, and select "Warp Text". Refresh the pivot table, then set the column width, and the text will auto-adjust. "Cash" wrote: I have a Pivot Table, when I refresh the table a certain column changes it format so that the alignment of the data is no longer centered (i.e. some data is aligned left, some aligned right, etc). I have 'Preserve Format' clicked. Also, in the data table that feeds the pivot table the specific data is 'aligned center'.... Any ideas how I can maintain a format? Cash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on Pivot Table Format | Excel Worksheet Functions | |||
pivot table format report - setting default | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |