| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze column width in a pivot table
Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off. Click OK Martha Navarro wrote: I am preparing an important document and I need to be able to "freeze the column width in a pivot table, so that when I enter more information the column won't change and show: ####### instead of an amount. thank you -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format a pivot table column - permanently? | Excel Discussion (Misc queries) | |||
| pivot table layout | Excel Discussion (Misc queries) | |||
| Keeping column width in Excel pivot table? | Excel Discussion (Misc queries) | |||
| Add a column outside pivot table and... | Excel Discussion (Misc queries) | |||
| Need to Add Column to Data in Pivot Table | Charts and Charting in Excel | |||
Hybrid Mode
