formatting Pivot table breaks
Hi Rob,
Have you checked your autoformat options to see if one of those formats
suits you? It's the button in the pivot table toolbar second from the left
called "Format Report".
If none of these works for you, you can manually format the rows you want
bolded etc. without losing your format on data refresh. Do it before you
apply any filters to your table. Also go into your Pivot table menu, Table
Options and make sure that the Autoformat table checkbox is UNchecked, and
the Preserve Formatting checkbox IS checked.
Hope this helps :-)
Helen
"Rob" wrote:
I have a simple pivot table that lists stuff. it lists States group by
region. On the region break of the pivot table (the summization line) I
would like to shade and bold the font. Is there a way to do that without
having to manually format each row... My concerning is if the data changes I
will loose my formatting.
Example:
NY 45.00
MA 450.00
Northeast regions 950.00 <-- I would like this line bold
FL 65.00
GA 27.00
Southern regions 92.00 <--- I would also like this link bold.
|