PC Review


Reply
Thread Tools Rate Thread

How can I select pivot table row totals to fill color them

 
 
Ruth5155
Guest
Posts: n/a
 
      17th Mar 2010
I have a pivot table with total rows. Other people in my team at work can
hover over the left edge of one of the total rows and all total rows get
selected so that a fill color can be applied. It does not work for me
 
Reply With Quote
 
 
 
 
Luke M
Guest
Posts: n/a
 
      17th Mar 2010
From the PivotTable tool bar, Click on the PivotTable dropdown, select -
Enable selection.

--
Best Regards,

Luke M
"Ruth5155" <(E-Mail Removed)> wrote in message
news:47441F7C-709C-4AC6-987A-(E-Mail Removed)...
>I have a pivot table with total rows. Other people in my team at work can
> hover over the left edge of one of the total rows and all total rows get
> selected so that a fill color can be applied. It does not work for me



 
Reply With Quote
 
de_koi
Guest
Posts: n/a
 
      19th Apr 2010

Ruth5155;937600 Wrote:
> I have a pivot table with total rows. Other people in my team at wor
> can
> hover over the left edge of one of the total rows and all total row
> get
> selected so that a fill color can be applied. It does not work for me

==========================================================
hi,
you can try to reset your excel setup. Go to Help >> Detect and Repai
>> Discard my customize setting and restore default settings >> start

It works for me so hopefully works for you too.


--
de_koi
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I select 2nd color for two-color gradient fill Office 2007 quattrodom Microsoft Powerpoint 2 18th Jul 2008 05:54 PM
Color fill cells to be added into totals =?Utf-8?B?aG9vbGllbw==?= Microsoft Excel Worksheet Functions 1 24th Oct 2007 07:03 AM
Pivot Table Totals ajames Microsoft Excel Misc 2 22nd Feb 2006 08:45 AM
Color fill doesn't let you select a color. Colors greyed out. =?Utf-8?B?RGlhbmU=?= Microsoft Word Document Management 4 28th Nov 2005 07:19 AM
Select or Filter by Fill Color Wil Microsoft Excel Worksheet Functions 1 4th Nov 2004 10:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:22 AM.