View Single Post
 
Old 11-26-2013, 03:07 PM
New Daddy New Daddy is offline Windows Vista Office 2003
Advanced Beginner
 
Join Date: Jan 2012
Posts: 90
New Daddy is on a distinguished road
Question Tweaking preset pivot table styles

Excel 2007.

I'm utilizing Excel's preset pivot table styles. While it makes formatting easy, I can't seem to make further changes, mostly with grouped items.

(1) Is there any way to get rid of the "+" button in front of a group, or at least make it invisible? When I copy and paste a pivot table into another application - like Word - the "+" button becomes too conspicuous, especially against other rows or columns that are not grouped.

(2) Grouped rows take on bolder font. Can I un-bold them? Nothing happens even when I click on the bold button in the Home tab. Again, the grouped rows become too conspicuous when I copy & paste the pivot table into other application.
Reply With Quote