View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
KSchmidt KSchmidt is offline
external usenet poster
 
Posts: 2
Default 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