Printing Problems

Fix Excel Checkboxes Moving When Printing or Scaling

Maira Mehtab Sep 22, 2026 870 views

Question details

The user is experiencing an issue where form-control checkboxes in a spreadsheet move or resize unexpectedly when the worksheet is scaled below 100% for printing.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Scaling an Excel worksheet below 100% for printing when it contains form-control checkboxes overlapping text or cells.
Observed behavior: The checkbox objects shift out of place, resize inappropriately, or move towards alternate text during the printing process.

Before you start

Check your Excel version to see if you have access to the newer in-cell checkbox feature, as upgrading your controls can permanently resolve object shifting issues.

Solution 1Recommended

Use New In-Cell Checkboxes

Replacing legacy form controls with the new in-cell checkboxes prevents movement and makes data easier to manage.

Excel's new in-cell checkbox feature embeds the control directly into the cell data rather than floating it as an independent shape. This completely eliminates resizing and moving issues during printing or scaling.

Insert the new checkbox

Select the cell where you want the checkbox to appear. Go to the Insert tab on the ribbon and click on 'Checkbox'.

Delete old form controls

Locate and delete the old floating form-control checkboxes that were previously shifting during printing.

Link formulas directly

Since the new in-cell checkbox directly stores a TRUE or FALSE value in the cell, you can update your formulas to reference this cell directly without needing complex control formatting.

Availability: The in-cell checkbox is a newer feature. If you do not see the Checkbox option under the Insert tab, you may need to update your Microsoft Office suite.

Solution 2

Adjust Boundaries and Ungroup Form Controls

If you must use older form controls, adjusting their boundaries and ungrouping them will stop them from shifting during printing.

Free Microsoft Office alternative

Avoid Printing Glitches with WPS Office

If Microsoft Excel's legacy form controls continue to disrupt your printed reports, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that handles objects and print scaling smoothly.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx document containing the form controls.
3. Print Seamlessly: Navigate to the print preview to scale and print your document. WPS Spreadsheets maintains strict object boundaries to prevent shifting.

Highly compatible with Microsoft Office formats (.xlsx) and legacy form controlsStable print rendering ensuring checkboxes and objects do not shiftLightweight application that is completely free to useFamiliar user interface for seamless and quick migration

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel checkboxes move when I print?

Excel form-control checkboxes can move during printing if the worksheet is scaled below 100%, if the checkbox boundaries overlap multiple cells, or if multiple form controls are grouped together.

How do I link the new in-cell checkbox to a formula?

The new in-cell checkbox directly stores a TRUE (checked) or FALSE (unchecked) value in its cell. You can simply reference that cell directly in your IF statements or other formulas without needing to use the 'Format Control' menu.

Does grouping objects cause printing issues in Excel?

Yes, grouping form controls or shapes can cause them to shift or scale incorrectly when printing or changing views. Ungrouping them and ensuring they fit exactly within cell borders helps maintain their exact position.

How do I lock a checkbox to a cell so it doesn't move?

Right-click the checkbox, select 'Format Control', navigate to the 'Properties' tab, and select 'Move but don't size with cells'. Combining this setting with keeping the checkbox entirely within one cell's boundaries prevents erratic movement.

Document & File Issues