Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping Column Widths the same in a pivot table when pages increase
I've created a pivot table and because of the length of the characters
in the page, the column width keeps changing. How do I keep the column width the same? |
#2
|
|||
|
|||
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTableTable Options Add a check mark to 'Preserve formatting', click OK Remove the check mark from AutoFormat Table Click OK wrote: I've created a pivot table and because of the length of the characters in the page, the column width keeps changing. How do I keep the column width the same? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |