Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11246
  • Last Modified:

Excel 2013 Pivot Table - Highlight Subtotal Rows

I have a pivot table that summarizes rows with a grand total row and grouped subtotal rows - I would like to set it up so it automatically highlights the subtotal rows. IOs there a way to do this?

Thanks
0
rogerdjr
Asked:
rogerdjr
3 Solutions
 
Rgonzo1971Commented:
Hi,

Here is a link to change the style of the Pivot table

http://www.contextures.com/excel-pivot-table-format.html

if you send a dummy maybe I could help on solving it

Regards
0
 
johnb25Commented:
Hi,

If you hover the mouse over the top edge of the first sub-total cell on the pivot table, the cursor will change to a down-arrow. Click to select all sub-total rows, and then apply the format you want.
It should then stick to the sub-totals as you filter or expand/collapse the rows.

John
0
 
Jerry PaladinoCommented:
Adding some visuals to john's post above showing as the cursor is placed next to any subtotal row it will change to a 'right' arrow to select all subtotal rows...then formatSelect Subtotal RowsFormat Subtotal Rows
0
 
rogerdjrAuthor Commented:
Thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now