How to Bold Subtotal Rows in Excel

How-to basics · Updated November 18, 2026

To bold subtotal rows created with Excel’s Subtotal command, collapse the outline to level 2, select the data area, choose Home > Find & Select > Go To Special > Visible cells only, and press Ctrl+B. This formats the displayed group subtotals and grand total without bolding the hidden detail rows. For subtotal rows you entered yourself, select their row headers and apply bold formatting.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a version of desktop Excel with the Subtotal command.
  • A normal, flat data range with column headings. The built-in Subtotal command does not work directly inside an Excel table; convert the table to a range first if necessary.
  • A grouping column, such as Department or Region, and at least one numeric column to summarize.

If you only need to format existing subtotal rows, you do not need to recreate them. Save a copy before making a large formatting change, especially if the workbook has complicated outlines or manually hidden rows.

Step-by-Step

  1. Check how the subtotal rows were made. Click a subtotal value and look at the formula bar. Subtotals made with Excel’s built-in command use the SUBTOTAL function and create an outline. If the row contains a manually entered SUM or label, use the manual-row method later in this section instead. Knowing which kind you have helps you choose the right way to select the rows.
  2. Sort the data by the grouping field if you are creating subtotals. Click a cell in the data and use Data > Sort to put matching group names together. For example, sort a sales list by Department before asking Excel to calculate a subtotal at each department change. The Subtotal command creates a summary whenever the selected field changes; unsorted data can therefore produce repeated subtotal groups that look incorrect.
  3. Create subtotals if they are not already present. Click a cell in the range, then choose Data > Subtotal. In the dialog, choose the grouping column in “At each change in,” select a calculation such as Sum in “Use function,” and tick the numeric columns to summarize under “Add subtotal to.” Leave “Summary below data” selected if you want each summary after its group. Choose OK. Excel inserts summary rows and outline controls to the left of the row numbers. If you already have subtotals, do not run the command again unless you intend to replace or add another level of summaries.
  4. Show the subtotal level of the outline. Click the outline level button marked 2, located above the row numbers on the left. This normally displays the column headings, group subtotal rows, and grand total while hiding the detail rows. Level 1 generally shows only the grand total; level 3 expands the details as well. If the outline buttons are missing in Windows, go to File > Options > Advanced, find “Display options for this worksheet,” and enable “Show outline symbols if an outline is applied.”
  5. Select the cells to format, excluding the headings. With the sheet at level 2, select the rectangular range covering the data columns from the first data row through the last subtotal or grand-total row. Do not include the column-heading row, or it will be included in the formatting operation. You can drag over the range, or enter its address in the Name Box to the left of the formula bar. Include all columns whose subtotal rows should appear bold, not just the column containing the subtotal amount.
  6. Limit the selection to visible cells. On the Home tab, choose Find & Select > Go To Special. Select “Visible cells only,” then click OK. This changes the selection so hidden detail rows are excluded. It is the key step: if you skip it, applying bold to a range that includes collapsed rows may format cells you meant to leave as normal-weight detail.
  7. Apply bold. Press Ctrl+B on Windows, or click Home > Bold in the Font group. The visible subtotal and grand-total rows in the selected range should now be bold. If you prefer the ribbon, the Bold button is the letter B; use its tooltip to confirm you have the correct control before clicking.
  8. Expand the outline and check the result. Click level 3 to show the detail rows again. Confirm that subtotal rows are bold and ordinary detail rows are not. If you want the grouped view afterward, click level 2 again. Changing the outline level only hides or displays rows; it does not remove the formatting you applied.

For subtotals you entered manually: Find each subtotal row, then click its row number at the left edge of the sheet. To select additional nonadjacent rows, hold Ctrl while clicking their row numbers on Windows, then press Ctrl+B. On Mac, use Command-click to add nonadjacent row headers and Command+B to bold. For a continuous block of subtotal rows, click the first row header and Shift-click the last. Selecting row headers formats the whole rows, including columns outside the visible data; select only the relevant cells instead if that is not what you want.

On Excel for Mac, the outline-level buttons and Subtotal command are available in desktop versions that support the feature, though ribbon placement can vary with the window layout. Use the Data tab to look for Subtotal, and use Home > Find & Select > Go To Special if available in your build. If a command is not on the ribbon, use Excel’s search box to locate it. Excel for the web has more limited support for creating and managing outlines; open the workbook in desktop Excel if you cannot create subtotals or select visible cells there.

Common Mistakes

  • Formatting the full range while details are expanded. This makes detail rows bold along with the summaries. Collapse to level 2 and use Go To Special > Visible cells only before applying bold.
  • Selecting the heading row. If the heading is in the selected range, it will also be affected. Start the selection at the first data row, not at the top of the worksheet or the column labels.
  • Using the Subtotal command inside an Excel table. The command is unavailable for a structured table. Click in the table, choose Table Design > Convert to Range, and confirm if you want to use the built-in outline-based Subtotal feature. Converting removes table behavior, so consider whether you still need table filters and automatic expansion first.
  • Forgetting to sort by the grouping column. Excel treats each change in the chosen field as a new group. Sort the list first if you expect one subtotal per department, month, or other category.
  • Clicking outline level 1 instead of 2. Level 1 commonly shows only the grand total, so it may seem as though the group subtotals disappeared. Click level 2 to display the group summaries.
  • Assuming bold is a subtotal setting. The Subtotal dialog controls which groups and calculations Excel creates; it is not a reliable substitute for checking the formatting. Inspect the result and apply bold explicitly when needed.

Tips

  • Apply the formatting after creating or updating subtotals. If you change the grouping field or rebuild the outline, check the new summary rows again rather than assuming the old formatting still matches.
  • Use level 2 as a quick visual check: if the sheet shows only the group summaries and grand total, you can compare the rows that should stand out before expanding the details.
  • If you want subtotal rows to be easier to scan, combine bold text with a subtle top border or fill color. Keep the style consistent across all groups, and check that the text remains readable when printed.
  • To remove bold later, select the same visible subtotal cells and press Ctrl+B again on Windows, or Command+B on Mac. If the selection contains a mix of bold and regular cells, check the result after toggling because mixed formatting can make the Bold button’s state harder to judge.
  • When using the manual method, select only the cells that should be emphasized if bolding the entire row would also affect notes, helper columns, or unrelated data.

Troubleshooting

The Subtotal button is unavailable. Check whether the data is formatted as an Excel table. Convert it to a range with Table Design > Convert to Range, or create summary rows another way. Also confirm that the sheet is not protected in a way that prevents structural changes.

Level 2 does not show the rows you expect. If there are no outline buttons, the range may not have been subtotaled, or outline symbols may be hidden. If there are nested subtotal levels, level 2 may show only one layer of summaries. Click level 3 to inspect the structure, and verify that the Subtotal dialog used the intended grouping field.

Detail rows became bold too. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if the formatting change is still the most recent action. Then collapse to level 2, reselect the data range, choose Go To Special > Visible cells only, and apply bold again. If other edits have been made since, manually select the affected detail rows and remove bold rather than undoing unrelated work.

The grand total is bold but group subtotals are not. The selection may have been made at outline level 1, which usually displays only the grand total. Click level 2, repeat the visible-cells selection across the data area, and apply bold. Also check that the selected range reaches every group subtotal row.

Go To Special is missing or disabled. Make sure you have selected a worksheet range first and that the worksheet is not protected against the action. If you are working in Excel for the web and cannot find the command, open the workbook in the desktop app. As a fallback, select each subtotal row header individually and apply bold, checking that you do not select detail rows.

Only the amount is bold, not the subtotal label. The selected range may cover just the numeric column. Repeat the process with a wider range that includes the label and other cells in each subtotal row. If you used the manual method, select the full row header or add the label cells to your selection.

Frequently Asked Questions

Does Excel automatically bold subtotal rows?
Do not rely on automatic formatting to make every subtotal stand out. The Subtotal command creates summary rows and an outline, but you can apply bold explicitly using the visible-cells method and verify the result.

Can I bold subtotal rows without hiding the detail rows permanently?
Yes. Collapse the outline temporarily, select visible cells only, and apply bold. Click level 3 afterward to show all details. The outline remains in the worksheet, and expanding it does not undo the bold formatting.

Can I use this method for rows with manually typed subtotals?
Not automatically with outline level 2, because manually typed summaries may not be part of an outline. Select their row headers or the specific cells, then use the Bold button or the appropriate keyboard shortcut.

Why can’t I use Data > Subtotal on my range?
A common reason is that the range is an Excel table. The built-in command is intended for a normal range. Convert the table to a range if you want that command, or keep the table and add and format summary rows separately.

Will sorting or refreshing the data keep the subtotal formatting?
Sorting an outlined list can affect the grouping, so check that matching categories remain together and that subtotals still correspond to the intended groups. If you remove and recreate subtotals, inspect the new rows and reapply formatting where necessary.

Can I bold only the subtotal label and amount?
Yes. After collapsing to level 2, select only the columns containing the label and subtotal value, then use Go To Special > Visible cells only and apply bold. The remaining cells in those rows will keep their existing formatting.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.