Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
|
|||
|
|||
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
How to clear the word '(blank)' from a cell in a Pivot Table | Excel Discussion (Misc queries) | |||
How do I get word wrap format to remain in an Excel pivot table? | Excel Discussion (Misc queries) | |||
Word Wrap | Excel Discussion (Misc queries) | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) |