How to Fix Excel PivotTable Slicer Font Spacing Bug in Calibri Bold
Question details
The user is encountering a rendering bug where custom Excel PivotTable slicers display condensed or incorrect spacing when formatted with Calibri Bold at sizes 9 or 10.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying custom font styles to PivotTable slicers to format dashboard reports.
- Observed behavior
- Text inside the slicer appears squished, condensed, or incorrectly spaced when Calibri Bold size 9 or 10 is applied, due to a rendering defect.
Before modifying your custom slicer styles, ensure you have isolated the issue by testing the slicer on a blank sheet to confirm it is the Calibri rendering defect and not a workbook corruption.
Workaround: Adjust Font Size or Font Family
Since this is a known Microsoft rendering defect, the most immediate solution is to change the font parameters so the slicer renders normally.
The spacing issue is specifically tied to how Excel renders the Calibri Bold font at smaller sizes (specifically 9 and 10) within the slicer user interface elements. Modifying either the font family or increasing the size bypasses the bug.
Click on the affected PivotTable slicer in your Excel worksheet to activate the Slicer tab on the ribbon.
Right-click the custom slicer style you are currently using in the Slicer Styles gallery and select 'Modify'.
Click 'Format', navigate to the Font tab, and either change the font size to 11 (or larger) or select a different font family (such as Arial or Segoe UI) while keeping the bold formatting.
Click 'OK' to save the changes. Check your slicer to ensure the text spacing is no longer condensed.

Report the Bug to Microsoft Support
To help get a permanent patch released, submit a formal bug report to the Excel engineering team with your reproduction steps.
Manage PivotTables Seamlessly in WPS Office
If rendering glitches and formatting bugs in Microsoft Excel are disrupting your data analysis, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling complex spreadsheets and PivotTables without the familiar UI quirks.
- 1. Download and Install: Get WPS Office from the official website and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file containing the custom PivotTable slicers.
- 3. Analyze Without Glitches: Manage your data and slicers with clean rendering and native compatibility.

Frequently Asked Questions
Why does my Excel slicer text look squished or condensed?
This is a known rendering defect in Excel that specifically occurs when slicer items are formatted with the Calibri font, set to Bold, and sized at exactly 9 or 10 points. The application miscalculates the character spacing for these specific parameters.
Can I permanently fix the Calibri 9 bold bug in Excel?
Only Microsoft can provide a permanent software patch for rendering bugs. Until an update is released, you must rely on workarounds such as changing the font size to 11 or switching to a different font like Arial.
Does this slicer formatting bug affect printed versions of my spreadsheet?
Rendering defects often only affect the on-screen display (the UI layer). However, it is highly recommended to use the Print Preview feature or print a test page to confirm whether the condensed spacing carries over to the physical document.




