Making Subtotals Bold

When you use the SUBTOTAL feature in the Data ribbon tab it automatically inserts subtotals in your list – see blog post on it here.

One problem with this is that is only makes the cell with the word Total bold – it doesn’t make the whole row bold.

If you want the whole row to be bold it isn’t hard to fix.

  1. Select the whole range involved.
  2. Use the grouping button 2 top left corner. See image below.
  3. Then hold the Alt key down and press the ; (semicolon key) – this selects just the visible cells.
  4. Then press Ctrl + b to bold it.
  5. Click another cell to reset the range and you are done.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply to Michael Rosen Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

4 thoughts on “Making Subtotals Bold”

  1. This was a huge help! Is there a way to use the #2 grouping and copy formulas down without it applying to every line in between?

    Reply