How do I highlight subtotals in a pivot table?

Show Subtotals at Top or Bottom

1. Select a cell in the pivot table, and on the Ribbon, click the Design tab.
2. In the Layout group, click Subtotals, and then click Show All Subtotals at Bottom of Group.

How do I Format subtotals in Excel 2010?

Click Format to display the Format Cells dialog box. Using the controls in the dialog box, set the formatting as you want it applied to the Grand Total row. Click OK to dismiss the Format Cells dialog box. Click OK to dismiss the New Formatting Rule dialog box.

How do you bold in a pivot table?

To modify an element’s formatting, click it to select it, and then click the Format button. (Note: In the Table Element list, the elements in bold font have formatting applied. You can modify or clear that formatting. You can also select unformatted elements and format them.)

Is there a way to make subtotals bold in Excel?

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.

How to calculate subtotals in a PivotTable in Excel?

When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the subtotals and grand totals with or without filtered items. Newer versions Office 2007 – 2010 Web Subtotal row and column fields

How to UN-bold a row in a pivot table?

Select the bold font row you want to un-bold in the pivot table, or you can press Ctrl key to select multiple bold font rows as your need. See screenshot: 2. Then click Home > Conditional Formatting > New Rule, see screenshot: 3. In the New Formatting Rule dialog box: (1.)

How to use subtotals to highlight rows in Excel?

We’ll use Subtotal with this data set. To generate the subtotals, click anywhere inside the data set and do the following: Click the Data tab. Click Subtotal in the Outline group.