Printing Problems

Fix Excel Checkboxes Not Printing or Showing in PDF

Muhammad Talha Sep 28, 2026 870 views

Question details

The user needs to make newly added cell-based checkboxes visible when printing a worksheet or exporting it to a PDF.

How to Fix Excel Checkboxes Not Printing or Appearing in PDF

Product: Microsoft Excel
Device & OS: not provided
Scenario: Printing an Excel worksheet or exporting the document to a PDF file.
Observed behavior: Cell-based checkboxes do not appear in the print preview, on the physical printout, or in the generated PDF file, regardless of whether they are checked or unchecked.

Before you start

Ensure your printer drivers are up to date and verify whether the issue happens across all worksheets or just a specific document before changing global print settings.

Solution 1Recommended

Disable Black and White Printing in Page Setup

This solution prevents Excel from stripping out the formatting of new cell-based checkboxes, which often disappear when forced to print in black and white.

The most common reason for new cell-based checkboxes disappearing during printing or PDF export is a conflict with legacy Page Setup configurations. When a worksheet is set to print exclusively in black and white, Excel may fail to render these modern cell elements.

Open the Print Menu

Navigate to the 'File' tab in the top-left corner of Excel and select 'Print' from the left sidebar, or simply press Ctrl + P on your keyboard.

Access Page Setup

Scroll to the bottom of the Print Settings pane and click on the 'Page Setup' link to open the configuration dialog box.

Adjust Sheet Settings

In the Page Setup dialog box, select the 'Sheet' tab at the top. Look under the 'Print' section and uncheck the box labeled 'Black and white'.

Apply and Verify

Click 'OK' to save the changes. Check the print preview pane to verify that your cell-based checkboxes are now clearly visible.

Disable Black and White Printing in Page Setup

Checkboxes Restored: Once color printing is enabled in the sheet setup, your checkboxes will accurately appear on physical printouts and exported PDF documents.

Solution 2

Verify Print Area and Object Settings

Ensures that your defined print area includes the checkbox cells and that Excel is permitted to print interactive objects.

Print Checkboxes Easily with WPS Office

Create and Print Checklists Seamlessly with WPS Spreadsheet

If you frequently encounter rendering or printing issues with Excel's page setup, WPS Spreadsheet offers a highly compatible and streamlined experience. You can seamlessly open your spreadsheets, utilize checkboxes, and export them directly to PDF with guaranteed visual accuracy.

1. Open Your File in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx workbook containing the checklists or forms.
2. Review Your Checkboxes: Navigate through your worksheet to ensure all interactive elements and checkboxes are displayed accurately in the WPS interface.
3. Export or Print: Click on the 'Menu' button at the top left. Select 'Export to PDF' for digital sharing or 'Print' for physical copies. WPS natively preserves the visibility of all checkboxes in the final output.

Fully compatible with Microsoft Excel (.xlsx) files and cell formatting.Native PDF exporter guarantees that checkboxes and objects render correctly.Lightweight software that runs smoothly without overwhelming system resources.Intuitive print preview settings to easily adjust layouts.

microsoft office alternative - wps office

Frequently Asked Questions

Why do older form control checkboxes print fine, but the new cell checkboxes disappear?

Excel treats older Form Control checkboxes as floating graphic objects, whereas the new cell-based checkboxes are tied directly to cell values. Legacy print settings like 'Black and white' printing aggressively strip specific cell formatting, which inadvertently hides the new cell-based checkboxes during rendering.

Can I save the document as a PDF without using the Print menu to bypass this bug?

You can try using 'File' > 'Save As' and selecting PDF, or 'File' > 'Export' > 'Create PDF/XPS'. However, because the 'Black and white' page setup setting is applied at the worksheet level, it can still cause checkboxes to vanish even when exporting directly to PDF. You must disable the setting in Page Setup first.

What if disabling black-and-white printing does not bring the checkboxes back?

If the issue persists, ensure your Office application is fully updated, as new cell-based checkboxes are a recent addition and early versions contained rendering bugs. Additionally, try clearing the print area or temporarily copying the data into a brand-new worksheet to clear corrupted print cache settings.

Document & File Issues