| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get word wrap format to remain in an Excel pivot table?
When working in a pivot table, I format a column or cells to word wrap.
However, once I manipulate the pivot table in any way (i.e. choose a new variable, or subcategory within a variable) the word wrap format goes away. I would like it to remain permanently. Any ideas? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get word wrap format to remain in an Excel pivot table?
There are instructions here for preserving the formatting applied to a
pivot table: http://www.contextures.com/xlfaqPivot.html#FormatLost KSchmidt wrote: When working in a pivot table, I format a column or cells to word wrap. However, once I manipulate the pivot table in any way (i.e. choose a new variable, or subcategory within a variable) the word wrap format goes away. I would like it to remain permanently. Any ideas? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get word wrap format to remain in an Excel pivot tabl
Thank you, Debra.
"Debra Dalgleish" wrote: There are instructions here for preserving the formatting applied to a pivot table: http://www.contextures.com/xlfaqPivot.html#FormatLost KSchmidt wrote: When working in a pivot table, I format a column or cells to word wrap. However, once I manipulate the pivot table in any way (i.e. choose a new variable, or subcategory within a variable) the word wrap format goes away. I would like it to remain permanently. Any ideas? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get word wrap format to remain in an Excel pivot tabl
You're welcome!
KSchmidt wrote: Thank you, Debra. "Debra Dalgleish" wrote: There are instructions here for preserving the formatting applied to a pivot table: http://www.contextures.com/xlfaqPivot.html#FormatLost KSchmidt wrote: When working in a pivot table, I format a column or cells to word wrap. However, once I manipulate the pivot table in any way (i.e. choose a new variable, or subcategory within a variable) the word wrap format goes away. I would like it to remain permanently. Any ideas? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| paste excel table to word | Excel Worksheet Functions | |||
| Paste table from excel to word | Excel Worksheet Functions | |||
Linear Mode
