Pivot Table Issues

How to Fix Undersized PivotTable Form Fields in Excel

Muhammad Talha Oct 22, 2026 868 views

Question details

The user needs to fix a display issue where the Table/Range and Location form fields in the Insert PivotTable dialog are too small, causing text to be cut off.

How to Fix Undersized PivotTable Form Fields in Excel

Product: Excel for Microsoft 365
Device & OS: Windows 11
Scenario: Attempting to insert a new PivotTable using the standard dialog box.
Observed behavior: Entered text in the Table/Range and Location fields gets cut off and becomes unreadable because the fields render undersized.

Before you start

Save your current Excel workbooks and close out of any unsaved applications, as you may need to sign out of your Windows account to fully apply display scaling changes.

Solution 1Recommended

Adjust Windows Display Scaling Settings

Modifying the system-level display scaling often resolves rendering bugs that cause Office dialog boxes to display incorrectly.

Excel relies on Windows system settings to render the size of its dialog boxes and text. If there is a mismatch or a scaling glitch in Windows 11, the fields in the Insert PivotTable dialog may shrink. Adjusting the scale forces the operating system to redraw these graphical elements properly.

Open Display Settings

Right-click on an empty area of your Windows desktop and select 'Display settings' from the context menu.

Modify the Scale

Scroll down to the 'Scale & layout' section. Click the 'Scale' dropdown menu and change the percentage (for example, if it is at 125%, change it to 100%, or vice versa).

Sign Out and Sign Back In

Click the Start menu, click your profile icon, and select 'Sign out'. Sign back into Windows to ensure the new scaling is applied universally.

Test the Dialog Box

Open Excel, select your data, and click 'Insert' > 'PivotTable' to verify that the Table/Range and Location fields are now appropriately sized.

Check Text Size settings: You can also check the 'Text size' settings under Windows Accessibility. If the global text size is set too high, it may cause text to overflow or appear cut off in fixed-size dialog boxes.

Solution 2

Update Graphics Drivers and Microsoft Office

Ensure both your system's graphics drivers and your Office software are up to date to eliminate known display rendering bugs.

Free Microsoft Office alternative

Switch to WPS Office to Avoid Display Rendering Bugs

If Excel continues to suffer from graphical glitches or dialogue box rendering issues on your Windows 11 device, consider switching to WPS Office. It provides a highly compatible, free alternative with robust, correctly rendering PivotTable features.

1. Open Your File in WPS: Launch WPS Spreadsheet and open your existing .xlsx workbook.
2. Insert a PivotTable: Highlight your data range, navigate to the 'Insert' tab, and click 'PivotTable'. The dialog box will render perfectly sized for your data entries.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files without formatting loss.Create, manage, and format PivotTables without encountering Windows-specific UI rendering bugs.Lightweight software package that runs smoothly on all devices without heavy system requirements.Familiar spreadsheet interface that requires zero learning curve for traditional Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the text cut off in my Excel PivotTable dialog box?

This is typically caused by a rendering bug related to Windows display scaling settings or an outdated graphics driver failing to draw Excel's user interface correctly.

Can I manually drag and resize the Insert PivotTable dialog box?

No, the standard 'Insert PivotTable' dialog box in Excel has a fixed dimension. You cannot manually drag its corners to resize it; the issue must be resolved through system-level display settings.

Will changing my Windows scale affect other applications on my computer?

Yes, adjusting the Windows display scale under system settings will affect the size of text, icons, and applications across your entire operating system, not just Microsoft Excel.

Excel & Data Problems