| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivotal table problem
In pivot table in Row column one of the field has more than 16 digits and any
changes in the page (in pivot) changes row with less than 16 character. In short, I need to change column with format cell. Can I keep the format of cell permanent with some command ? It should not change even with change in page filter. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivotal table problem
Right-click on a cell in the pivot table
Choose Table Options Remove the check mark from AutoFormat table Click OK Vijay Kotian wrote: In pivot table in Row column one of the field has more than 16 digits and any changes in the page (in pivot) changes row with less than 16 character. In short, I need to change column with format cell. Can I keep the format of cell permanent with some command ? It should not change even with change in page filter. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data table based on data table | Excel Discussion (Misc queries) | |||
| Pivot table Refresh problem | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| data table problem | Excel Discussion (Misc queries) | |||
| Problem with linked Excel table in a word Document | Excel Discussion (Misc queries) | |||
Hybrid Mode
