How to remove bold font of pivot table in Excel?
After creating a pivot table in a worksheet, you will see the font of row labels, subtotal rows and Grand Total rows are bold. If you want to un-bold these rows, the first consider is to apply the Bold feature to remove the bold font. But, in pivot table, you will find this feature will not work normally. Today, I will talk about how to quickly remove bold font in pivot table.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
The normal Bold feature can’t help us to un-bold the row labels in pivot table, but we can apply the powerful function – Conditional Formatting to solve this problem. Please do as follows:
1. 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.) Click Use a formula to determine which cells to format option under Select a Rule Type section;
- (2.) Then enter this formula =$A$3="Row Labels" into the Format values where this formula is true field, see screenshot:
Note: In the above formula, A3 indicates the first cell reference of bold font rows in your pivot table, and the Row Labels is the cell content of your cell A3. You can change them to your need.
4. Then click Format button, and in the popped out Format Cells dialog, click Font tab, and then choose Regular from the Font style, see screenshot:
5. And then click OK > OK to close the dialogs, and now, you can see your selected bold font rows have been showed as un-bold font, see screenshot: