Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-26-2013, 03:07 PM
New Daddy New Daddy is offline Tweaking preset pivot table styles Windows Vista Tweaking preset pivot table styles Office 2003
Advanced Beginner
Tweaking preset pivot table styles
 
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
  #2  
Old 12-12-2013, 05:20 PM
differentdrummer differentdrummer is offline Tweaking preset pivot table styles Windows XP Tweaking preset pivot table styles Office 2007
Novice
 
Join Date: Nov 2013
Posts: 10
differentdrummer is on a distinguished road
Default

Re the first question
"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."

Pivot table options -> display -> then untick the show expand/collapse buttons

Can't help you with question 2 !
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table uhlersa Excel 0 10-15-2012 12:01 PM
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Tweaking preset pivot table styles pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Tweaking preset pivot table styles Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
Tweaking preset pivot table styles Pivot Table Karen615 Excel 5 08-03-2011 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft