Is there a way to keep the formating after you use a filter? If I create a
pivot table, add some color and adjust columns its fine. If I use a filter
after that the spacing changes and sometimes the colors revert back to white.
Seems I've always had this problem. Im currently using Excel 2003.

Thanks

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 PivotTableSelect
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 subtotals


Str8 wrote:
Is there a way to keep the formating after you use a filter? If I create a
pivot table, add some color and adjust columns its fine. If I use a filter
after that the spacing changes and sometimes the colors revert back to white.
Seems I've always had this problem. Im currently using Excel 2003.

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

In my spreadsheet, my month column is formatted as October, but when I
create my pivot table, it reverts back to 1/1/1900. Why won't it preserve
my formatting?
Thanks.

Thanks works. I really appreciate it.

"Str8" wrote:

Is there a way to keep the formating after you use a filter? If I create a
pivot table, add some color and adjust columns its fine. If I use a filter
after that the spacing changes and sometimes the colors revert back to white.
Seems I've always had this problem. Im currently using Excel 2003.

Thanks

Just wanted to say thanks again. I have a bunch of spreadsheets that don't
use pivot tables that I have connected to Access databases. After I ran the
refresh on those reports and the new data was brought in, the column widths
would change and I'd have to manually change them back. Just found out if I
right click, go to data range properties and uncheck adjust column width, I
don't need to manually change columns back after I refresh in the new data.

Thanks

"Str8" wrote:

Is there a way to keep the formating after you use a filter? If I create a
pivot table, add some color and adjust columns its fine. If I use a filter
after that the spacing changes and sometimes the colors revert back to white.
Seems I've always had this problem. Im currently using Excel 2003.

Thanks