'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Very Small Text in Excel Dialog Boxes
Question details
The user needs to resolve an issue where the text inside Excel's pop-up windows and wizards is too small to read.
- Product
- Microsoft Excel
- Device & OS
- Windows 10 / Windows 11
- Scenario
- Opening Excel dialog boxes, internal settings, or wizards on a high-resolution display.
- Observed behavior
- The main Excel window and worksheet appear completely normal, but the text inside internal dialog boxes and wizards appears unusually small.
Ensure you have saved all open workbooks and completely closed Microsoft Excel before modifying your system display settings or adjusting graphics drivers.
Adjust Windows Display Scaling and Text Size
Modify the system-wide display settings in Windows to ensure that high-resolution displays scale Excel dialog boxes properly.
High-resolution monitors can sometimes cause legacy dialog boxes in Excel to render at their native pixel size, making them appear extremely small. Adjusting the Windows scale layout forces these elements to resize.
Click the Start menu and go to Settings > System > Display. Under the 'Scale and layout' section, choose a higher percentage from the drop-down menu. Alternatively, navigate to Ease of Access > Display to adjust the overall text size slider.
Open Settings > System > Display and adjust the 'Scale' percentage. You can also go to Settings > Accessibility > Text size to increase the font size across the operating system.
After applying the new scaling settings, reopen Excel and trigger a dialog box (such as the Format Cells window) to verify if the text size has normalized.
Troubleshoot Graphics Drivers in Device Manager
Resolve potential rendering conflicts by testing and isolating multiple display adapters.
Experience Flawless UI Scaling with WPS Office
If Microsoft Excel continues to suffer from dialog box scaling issues on your high-resolution display, consider switching to WPS Office. It provides a flawlessly scaled, high-DPI optimized spreadsheet experience without complex configuration.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button to get the installer.
- 2. Install WPS Office: Run the downloaded file and follow the quick installation wizard to set up the software on your Windows PC.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing Excel files to enjoy perfectly scaled menus and dialog boxes.
Frequently Asked Questions
Why is my main Excel worksheet normal but the dialog boxes are tiny?
This discrepancy occurs because the main worksheet canvas uses independent zoom controls (handled by the application), while legacy pop-up dialog boxes rely on system-wide Windows DPI scaling. On high-resolution displays, these legacy UI elements may fail to scale up appropriately.
Will changing Windows display scaling affect my other applications?
Yes, modifying the 'Scale and layout' or text size in Windows Settings is a system-wide change. It will enlarge text, icons, and menus across all software installed on your computer.
Can I fix the scaling for Excel without changing my global Windows settings?
You can try adjusting the compatibility settings for Excel. Right-click the Excel shortcut, select Properties, navigate to the Compatibility tab, click 'Change high DPI settings', and check the box to 'Override high DPI scaling behavior', setting it to be performed by 'System'.
What should I do if disabling the graphics driver makes my screen go black?
If your screen goes black after disabling a display adapter, wait a few minutes as Windows usually recovers and switches to the basic display driver. If it doesn't, force restart your computer by holding the power button; Windows will boot using the default driver so you can re-enable the device.
