How to Fix Excel Check Box Not Showing When Printing to PDF
Question details
The user is unable to see check boxes in the generated PDF file after attempting to print or export an Excel worksheet.

- 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.
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.
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.
Right-click the missing check box in your Excel sheet and select 'Format Control' from the context menu.
In the Format Control dialog box, click on the 'Properties' tab.
Check the box next to 'Print object' and click 'OK' to apply the changes.

Use Save As or Export to PDF
Bypassing the print spooler by saving directly to PDF can prevent rendering issues caused by certain printer drivers.
Switch to a Reliable PDF Printer Driver
Some third-party PDF printers struggle to render Excel form controls correctly. Switching to Microsoft's native PDF printer often resolves this.
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. Open your Spreadsheet: Open your Excel spreadsheet containing the check boxes in WPS Spreadsheet.
- 2. Access the Menu: Click the 'Menu' button in the top left corner of the application.
- 3. Export to PDF: Select 'Export to PDF' from the dropdown list.
- 4. Complete the Export: Configure your export settings as needed and click 'Export' to generate a flawless PDF.

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'.




