Fix Small Checkboxes and Misaligned Fonts in Excel 2016 Print Preview
Question details
Resolve small, misaligned checkboxes and fonts in Excel 2016 print preview and printed output when the same workbook prints correctly for other users.
- Product
- Microsoft Excel 2016
- Device & OS
- Windows; version not provided
- Scenario
- One user prints a shared workbook using the same printer and print settings as users whose output is correct.
- Observed behavior
- Checkboxes and fonts appear small or misaligned in both print preview and printed pages for one user, but not for others.
Open the same workbook on the affected computer and a working computer, and select the same printer under File > Print. Record the Excel version, Windows display scaling, and printer-driver version before changing settings.
Compare the affected user's display and Excel print settings
Start here when the workbook prints correctly for other users; the difference may be specific to the affected computer or Windows profile.
In Excel, open File > Print on both computers. Compare the selected printer, paper size, orientation, margins, and scaling, then check Page Layout > Page Setup for additional differences.
Open Windows Settings > System > Display and compare the scale and display resolution with the working computer. If scaling differs, test with the working computer's scale setting where appropriate, then close and reopen Excel; sign out if Windows requests it.
Open File > Account > About Excel on both computers and compare the version and build. If available, use File > Account > Update Options > Update Now on the affected computer; contact your administrator if updates are managed.
If an authorized second Windows account is available on the affected computer, sign in with it and open the workbook in Excel. Select the same printer under File > Print and compare the preview to determine whether the problem is profile-specific or computer-wide.
Test Excel in Safe Mode and repair Office if needed
Use this approach to check for add-in interference or a problem with the local Office installation.
Check and update the affected user's printer driver
Use this solution when settings and Office checks do not resolve the issue, especially if printer drivers differ between computers.
Try WPS Spreadsheet for an Alternative Excel Printing Workflow
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move everyday spreadsheet work. It does not repair Excel 2016, but you can test the workbook's print layout in WPS Spreadsheet. Verify checkbox rendering before relying on the output.
Frequently Asked Questions
Why does the same Excel workbook print correctly for other users?
The difference may be in the local Excel installation, Windows display scaling, add-ins, or printer driver rather than the workbook. Compare File > Print, File > Account > About Excel, and Windows Settings > System > Display with a working computer.
Can Windows display scaling affect checkbox alignment in Excel print preview?
Display scaling can contribute to rendering differences for worksheet controls in some configurations. Compare Settings > System > Display with a working computer, test an appropriate matching scale, and reopen Excel before checking File > Print again.
What does it mean if the workbook looks correct in Excel Safe Mode?
It suggests an add-in or startup customization may be contributing. Start Safe Mode with Windows + R > excel /safe, then use File > Options > Add-ins in normal mode to disable and test add-ins individually.
Should I resize the checkboxes to fix the affected user's printout?
Not initially. If other users get correct output from the same workbook, resizing the controls could disrupt their layout. First compare local settings, test Safe Mode, and check the printer driver.
Will WPS Office fix the Excel 2016 installation?
No. WPS Office is an alternative spreadsheet application, not an Excel repair tool. Open a copy of the workbook in WPS Spreadsheet and inspect its print preview; checkbox and control compatibility can vary, so verify the layout before printing.
