Word wrap in a pivot table
everytime i do a sort for data, such as on one client or another, the column
with case notes looses the formating.... and word wrap is lost.... is there anything i can do to make it not loose the word wraping each time? Thank you again -- thank you, Lorie |
Word wrap in a pivot table
Right-click on a cell in the pivot table and choose Table Options
Make sure that the Preserve Formatting box is checked. Lorie wrote: everytime i do a sort for data, such as on one client or another, the column with case notes looses the formating.... and word wrap is lost.... is there anything i can do to make it not loose the word wraping each time? Thank you again -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Word wrap in a pivot table
it was checked....
-- thank you, Lorie "Debra Dalgleish" wrote: Right-click on a cell in the pivot table and choose Table Options Make sure that the Preserve Formatting box is checked. Lorie wrote: everytime i do a sort for data, such as on one client or another, the column with case notes looses the formating.... and word wrap is lost.... is there anything i can do to make it not loose the word wraping each time? Thank you again -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
I found a working solution he http://www.mrexcel.com/archive/Pivot/14589.html
" Format Text in a Pivot Table Posted by Mark W. on April 14, 2001 1:53 PM Malc, setting the "Preserve formatting" PivotTable Format option isn't prescriptive by itself. You also must set Enable Selection by right-clicking on your PivotTable and choosing the "Select Enable Selection" command. Once you've done this you must right-click on the PivotTable once again and choose the "Select Label" command. Now you can select the desired field label, and apply the Alignment Wrap text format. I should also mention that prior to performing these steps you may want to temporarily set all PAGE fields to "(All)". If you don't your applied formatting will only be established for the existing settings. For more on this see the Excel Help topic for "Format a PivotTable". Hope this helps!" Quote:
|
All times are GMT +1. The time now is 10:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com