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. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings
Format the selected headings


LordCommando wrote:
I designed a Pivot table to look at various data, with 2 fields in the
column section. The information is perfectly accurate, but because of
the quantity of information, I have to set a specific alignment for
readability for the 2 fields. If I add information and refresh, I'm
loosing a portion of my formating. What should I do?

Take a look at these 2 images for a better idea of the problem:

http://i141.photobucket.com/albums/r...xcelbefore.jpg
first image, look at line 4, properly aligned.

second image after refresh, line 4 is not the same anymore. sniff :(
http://i141.photobucket.com/albums/r...Excelafter.jpg
Any help will be welcomed.

Lord Commando Of the Styx



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html