| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping column width in Excel pivot table?
Dear reader,
I'm looking for a way to keep widths of columns in Excel pivot table report stable whenever I make changes to the table's contents. So far, every time I pick something different from drop-down lists, my pivot table report automatically adjusts column widths and I have to format it all over again to be able to fit into a page for printing purposes, which is very frustrating. If you know better than this - be sure to let me know!!! :) Thanks you for help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping column width in Excel pivot table?
Right-click a cell in the pivot table, and choose Table Options
Add a check mark to Preserve Formatting Remove the check mark from AutoFormat table. Click OK Polina wrote: Dear reader, I'm looking for a way to keep widths of columns in Excel pivot table report stable whenever I make changes to the table's contents. So far, every time I pick something different from drop-down lists, my pivot table report automatically adjusts column widths and I have to format it all over again to be able to fit into a page for printing purposes, which is very frustrating. If you know better than this - be sure to let me know!!! :) Thanks you for help! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| "Cumulative" column based on a pivot table sum column? | Excel Worksheet Functions | |||
| Pasting HTML table with feet/inches column, excel changes it to da | Excel Discussion (Misc queries) | |||
| Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Hybrid Mode
