'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Checkboxes Not Printing or Showing in PDF
Question details
Users are unable to see newly added checkboxes in their Excel Print Preview, and the checkboxes are missing when exporting the worksheet to a PDF file.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing a worksheet that contains form controls or saving/exporting the document to a PDF format.
- Observed behavior
- Checkboxes do not render in the output document or print preview when the worksheet printing configuration is set to black-and-white.
Ensure your printer drivers are up to date and verify that the checkboxes are visible in the normal worksheet view before adjusting print settings.
Disable Black-and-White Printing in Page Setup
Disabling the black-and-white print setting forces Excel to render all colored elements and form controls, ensuring checkboxes appear correctly in prints and PDFs.
Excel sometimes suppresses form controls like checkboxes when the sheet is explicitly set to print in black and white. By turning off this specific setting in Excel and relying on your printer's color settings instead, the elements will render correctly.
Navigate to the 'Page Layout' tab on the top ribbon and click the small diagonal arrow icon (dialog box launcher) in the bottom right corner of the 'Page Setup' group.
In the Page Setup dialog box that appears, click on the 'Sheet' tab at the top.
Look under the 'Print' section and uncheck the box next to 'Black and white'.
Click 'OK' to save the changes. Go to 'File' > 'Print' to verify that the checkboxes now appear in the Print Preview window.
Print Spreadsheets Flawlessly with WPS Office
WPS Spreadsheet offers a highly compatible and user-friendly interface for managing, printing, and exporting documents to PDF without losing form controls like checkboxes.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the missing checkboxes.
- 2. Go to Print Preview: Click on the 'Menu' button in the top left corner and select 'Print Preview' to check if all elements are visible.
- 3. Adjust Page Setup: Click 'Page Setup' within the Print Preview toolbar, go to the 'Sheet' tab, and ensure 'Black and white' is unchecked.
- 4. Print or Export: Proceed to print the document or click 'Export to PDF' directly from the toolbar to generate a complete document.
Frequently Asked Questions
Why do some Excel form controls print while others don't?
Form controls have individual properties. If a specific checkbox isn't printing while others do, right-click the problematic checkbox, select 'Format Control', go to the 'Properties' tab, and ensure the 'Print object' box is checked.
Can I print checkboxes in black and white without losing them?
Yes. Instead of using Excel's built-in 'Black and white' sheet setting, leave it unchecked. Then, click 'Printer Properties' in the Print menu and change your actual printer's settings to print in grayscale. This forces the printer to handle the color conversion rather than Excel stripping the controls out.
Does saving as PDF instead of printing to PDF fix the missing checkbox issue?
Usually, both methods rely on the same Page Setup settings. If 'Black and white' printing is enabled in the Sheet settings, the checkboxes may still be omitted regardless of whether you 'Save As PDF' or 'Print to PDF'.
Are ActiveX checkboxes different from Form Control checkboxes when printing?
Yes. ActiveX controls sometimes behave differently during printing or PDF export depending on display scaling or security settings. If an ActiveX checkbox fails to print despite correct settings, try replacing it with a standard Form Control checkbox from the Developer tab.
