software

Is it possible to set a default cell format in a pivot table that works even
when you update the pivottable and get more rows?

(e.g. wrap text)

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTablegt;Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. subtotals --
Move the pointer to the left of a subtotal heading in the pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select the subtotal rows in the pivot
table.
Format the selected subtotalsCF wrote:
gt; Is it possible to set a default cell format in a pivot table that works even
gt; when you update the pivottable and get more rows?
gt;
gt; (e.g. wrap text)--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlThanks for the answer.
My problem now is that the row height does not change automatically when I
have wrapped the text in cells. How do I solve this?

/C-F

quot;Debra Dalgleishquot; skrev:

gt; Right-click a cell in the pivot table, and choose Table Options
gt; Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
gt; Click OK
gt;
gt; To format cells, enable selection should be turned on.
gt; To enable selection --
gt; From the Pivot toolbar, choose PivotTablegt;Select
gt; If it's not already activated, click on Enable Selection
gt;
gt; To format a section of a pivot table, e.g. subtotals --
gt; Move the pointer to the left of a subtotal heading in the pivot table.
gt; When the black arrow appears (like the one that appears when the pointer
gt; is over a row button), click to select the subtotal rows in the pivot
gt; table.
gt; Format the selected subtotals
gt;
gt;
gt; CF wrote:
gt; gt; Is it possible to set a default cell format in a pivot table that works even
gt; gt; when you update the pivottable and get more rows?
gt; gt;
gt; gt; (e.g. wrap text)
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;