| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofit columns in pivot table
I am using Excel 2002.
Whenever I change the order of the row items in the layout of a pivot table, the column widths are inappropriate for the data that they contain, and I must readjust them. Is there not a way to ensure that this happens automatically? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofit columns in pivot table
You can try the AutoFormat option --
Right-click on a cell in the pivot table Choose Table Options Add a check mark to AutoFormat table Click OK Pastel Hughes wrote: I am using Excel 2002. Whenever I change the order of the row items in the layout of a pivot table, the column widths are inappropriate for the data that they contain, and I must readjust them. Is there not a way to ensure that this happens automatically? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofit columns in pivot table
Unfortunately, there was already a check mark in the "Autoformat Table" box.
For some reason it doesn't seem to cover column-widths "Debra Dalgleish" wrote: You can try the AutoFormat option -- Right-click on a cell in the pivot table Choose Table Options Add a check mark to AutoFormat table Click OK Pastel Hughes wrote: I am using Excel 2002. Whenever I change the order of the row items in the layout of a pivot table, the column widths are inappropriate for the data that they contain, and I must readjust them. Is there not a way to ensure that this happens automatically? -- 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 | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Pivot tables - inserting columns | Excel Worksheet Functions | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
Hybrid Mode
