How to Fix Excel Checkboxes Printing as Tiny Boxes
Question details
The user needs to fix an issue where Excel checkboxes print extremely small from one specific computer.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing a shared workbook containing form control or ActiveX checkboxes from a computer.
- Observed behavior
- Checkmark boxes display correctly on the screen for all users, but appear as tiny boxes in Print Preview and on the physical paper when printed from one affected computer.
Verify whether the issue occurs with all documents or just this specific shared workbook, and check if you have administrative privileges on the affected computer to install or update printer drivers if necessary.
Adjust Excel Print Scaling Settings
Check and reset the print scaling options, as incorrect scaling can cause form controls to shrink during the print process.
Excel's print scaling feature is designed to fit your data onto a specific number of pages, but it can sometimes disproportionately scale ActiveX or Form Control checkboxes compared to the text.
Navigate to the 'Page Layout' tab on the Excel ribbon and click the small diagonal arrow in the bottom right corner of the 'Page Setup' group.
Under the 'Page' tab in the Page Setup dialog box, look at the Scaling section. Ensure 'Adjust to:' is set to '100% normal size' rather than 'Fit to'.
Go to 'File' > 'Print' to view the Print Preview and see if the checkboxes now display at their normal size.

Update or Reinstall Printer Drivers
Since the workbook prints perfectly from other computers, the issue is likely tied to the specific printer driver on the affected machine.
Export the Workbook to PDF Before Printing
Use PDF export as a reliable workaround to lock in the correct visual dimensions of the checkboxes.
Print Spreadsheets Flawlessly with WPS Office
Avoid Excel's notorious form control and display scaling bugs by opening and printing your spreadsheets with WPS Office. WPS provides a highly stable print engine and built-in PDF tools that ensure your checkboxes and data print exactly as they appear on the screen.
- 1. Open Your Spreadsheet in WPS: Launch WPS Office and open your .xlsx file containing the checkboxes. WPS will seamlessly load all form controls.
- 2. Verify Checkbox Size: Scroll through your document to ensure the checkboxes look correct on your screen.
- 3. Access Print Preview: Click on the 'Menu' button and select 'Print Preview'. You will notice the checkboxes maintain their proper size.
- 4. Print or Export: Click the 'Print' icon to send it directly to your printer, or use the 'Export to PDF' button on the toolbar to save a fixed-layout copy.

Frequently Asked Questions
Why do my Excel form controls change size when printing?
This is typically caused by a conflict between your Windows display scaling settings (such as 125% or 150%) and the printer driver's resolution. When Excel sends the print job, the graphical dimensions of shapes and form controls can be incorrectly calculated, causing them to shrink or grow.
Do ActiveX checkboxes behave differently than Form Control checkboxes?
Yes, ActiveX controls are much more susceptible to resizing issues during printing or when moving a workbook between monitors with different resolutions. Standard Form Controls are generally more stable, though they can still occasionally suffer from scaling bugs.
Will clearing the print area help fix the tiny checkbox issue?
Clearing and resetting the print area usually fixes issues where data is cut off, but it rarely fixes scaling issues with specific elements like checkboxes. Focus on adjusting the Page Setup scaling to 100% or updating your printer drivers instead.
Why does the workbook print fine from other computers?
Because the printer drivers, Windows display scaling settings, and default printer configurations vary from machine to machine. The affected computer likely has an outdated printer driver or a custom high-DPI scaling setting that the working computers do not have.




