With a few simple keyboard shortcuts, you can make the subtotals in your Excel data stand out with a bold-face font. By default, subtotals generated by Excel's automatic Subtotals feature display in a regular font, making them hard to distinguish from other rows. With a simple technique, you can select all of your subtotal rows at once and apply a bold font, border lines or even a fill color to the rows.

Step 1

Open the worksheet containing data sorted with the Subtotals feature.

Step 2

Press "Ctrl-8" to show the outline section if it's hidden. The outline section is the area to the left that shows the subtotal groupings.

Step 3

Click the "2" button in the outline section to collapse the data so that only the subtotal rows show.

Step 4

Click anywhere in the data and press "Ctrl-A" to select the table.

Step 5

Press the "Alt" and ";" keys simultaneously to limit the selection to only the visible cells.

Step 6

Press "Ctr-B" to make the subtotals bold-faced.

Step 7

Press "Ctrl-1" to open the Format Cells dialog box if you want to make the rows stand out even more. Use the options under the "Border" tab to add a line across the top or bottom of the rows, or use the "Fill" tab options to apply color to the rows.


  • Information in this article applies to Microsoft Excel 2013 and 2010. It may vary slightly or significantly with other versions.