Format Subtotal Rows

August 03, 2017 - by Bill Jelen

Excel bolds one column on the Subtotal Rows

It is a little odd that Subtotals only bolds the customer column and not anything else in the subtotal row. Follow these steps to format the subtotal rows:

1. Collapse the data to the #2 view.

2. Select all data from the first subtotal to the grand totals.

3. ---

   ---

   Press Alt + ; (which is the shortcut for Go To Special, Visible Cells Only).

   

4. Click OK. Format the subtotal rowsby applying Bold and a fill color.

Now, when you go back to the #3 view, the subtotal rows will be easy to spot.

Watch Video

Title Photo: surpriseapeartree / pixabay