Printing Problems

How to Fix Excel Check Box Not Showing When Printing to PDF

Steven ParkerSteven Parker Nov 10, 2026 869 views

Question details

The user is unable to see check boxes in the generated PDF file after attempting to print or export an Excel worksheet.

How to Fix Excel Check Box Not Showing When Printing to PDF
Product
Excel
Device & OS
not provided
Scenario
Converting or printing an Excel spreadsheet containing check boxes into a PDF document.
Observed behavior
The check boxes are visible in the Excel worksheet but disappear or fail to render in the resulting PDF file.
Before you start

Make sure your spreadsheet is saved, and verify whether you are using form controls or ActiveX controls for your check boxes, as this can affect printing behavior.

Solution 1Recommended

Enable 'Print Object' in Format Control

Check boxes must be explicitly set to print in their object properties, otherwise they will be hidden during printing or PDF export.

By default, Excel might treat some inserted objects as non-printable to save ink. You need to explicitly tell Excel that the check box should be included in the print job.

1
Open Format Control

Right-click the missing check box in your Excel sheet and select 'Format Control' from the context menu.

2
Navigate to Properties

In the Format Control dialog box, click on the 'Properties' tab.

3
Enable Print Object

Check the box next to 'Print object' and click 'OK' to apply the changes.

Enable 'Print Object' in Format Control
Tip: If you have multiple check boxes, you can hold 'Ctrl' and click each one to select them all, then right-click to apply the 'Print object' setting to all of them simultaneously.
Seamless PDF Export

Use WPS Office to Print and Export PDFs Flawlessly

WPS Office offers a built-in, highly compatible PDF converter that perfectly retains Excel form controls, including check boxes, without requiring complex property adjustments or third-party drivers.

  1. 1. Open your Spreadsheet: Open your Excel spreadsheet containing the check boxes in WPS Spreadsheet.
  2. 2. Access the Menu: Click the 'Menu' button in the top left corner of the application.
  3. 3. Export to PDF: Select 'Export to PDF' from the dropdown list.
  4. 4. Complete the Export: Configure your export settings as needed and click 'Export' to generate a flawless PDF.
Free and lightweight Office suiteFully compatible with Microsoft Excel (.xlsx) formatsNative PDF export that preserves formatting and objects perfectlyIntuitive interface similar to Microsoft Office for seamless migration
microsoft office alternative - wps office

Frequently Asked Questions

Why do some elements like shapes or buttons not print in Excel?

Similar to check boxes, shapes and buttons have a 'Print object' property. If this setting is unchecked in the Format Control or Size and Properties menu, the elements will not appear on the printed page or in the exported PDF.

Are ActiveX check boxes better for printing than Form Control check boxes?

Not necessarily. Form Control check boxes are generally more stable and easier to format for printing. ActiveX controls can sometimes scale improperly or disappear during printing due to display scaling and compatibility issues.

Can I print a check box without printing the cell gridlines?

Yes. You can disable gridlines from printing by navigating to the 'Page Layout' tab, finding the 'Sheet Options' group, and unchecking the 'Print' box located under 'Gridlines'.