'%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)
Fix Excel Checkboxes Exporting as TRUE or FALSE in PDF
Question details
The user needs to resolve an issue where checkboxes in a worksheet are converted to the text TRUE or FALSE instead of displaying as visual checkmarks when exported or printed to a PDF document.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or printing a spreadsheet containing form control checkboxes into a PDF file format.
- Observed behavior
- The visual checkboxes disappear in the resulting PDF and are replaced by the boolean text values TRUE or FALSE.
Before attempting to change your workbook formatting, ensure that your PDF viewing application is fully up-to-date, as older PDF readers sometimes struggle to render form controls properly.
Open the PDF with Microsoft Edge or a Modern Reader
Often, the spreadsheet exports perfectly fine, but the PDF viewer you are using fails to render the form objects, falling back to displaying their linked text values.
Form controls like checkboxes are interactive elements. Some basic or outdated PDF viewers cannot process these objects and will default to showing the underlying boolean data (TRUE/FALSE) instead of the graphic.
Find the PDF file you exported from Excel in your computer's File Explorer.
Right-click the PDF file, hover over 'Open with', and select 'Microsoft Edge' from the list of applications.
Check if the checkboxes now display correctly as visual boxes instead of text strings. If they do, your original export was successful, and the issue lies with your previous PDF viewer.
Create a Clean Test Workbook to Isolate the Issue
Testing a blank file helps determine if complex formulas, specific cell links, or corrupted formatting in your original file are causing the export failure.
Use Formatted Symbols as a PDF-Friendly Alternative
If standard form controls continue to fail during the PDF conversion, using text-based symbols guarantees that the checkmarks will render identically across all PDF viewers.
Export Spreadsheets to PDF Seamlessly with WPS Office
WPS Office provides an advanced, built-in PDF converter that accurately processes form controls. By using WPS Spreadsheets, you can easily export checkboxes, charts, and complex formatting to PDF without losing graphical elements or seeing TRUE/FALSE text errors.
- 1. Open your file in WPS: Launch WPS Spreadsheets and open your .xlsx file containing the checkboxes.
- 2. Access the Export menu: Click the 'Menu' button in the top-left corner of the interface.
- 3. Select Export to PDF: Choose 'Export to PDF' from the dropdown list to open the conversion dialog.
- 4. Save your PDF: Confirm your export settings, such as the page range, and click 'Export'. Your checkboxes will be perfectly preserved in the final document.
Frequently Asked Questions
Why does my printed PDF show the words TRUE or FALSE next to the checkbox?
When a Form Control checkbox is linked to a cell, that cell displays the boolean state of the box (TRUE when checked, FALSE when unchecked). If the cell text is not hidden (for example, by matching the text color to the background), the PDF exporter will print these words directly onto the document.
How do I ensure checkbox objects are set to print in Excel?
Right-click the checkbox and select 'Format Control'. Navigate to the 'Properties' tab and ensure the 'Print object' box is checked. If this is unchecked, the checkbox graphic will intentionally be left out of printed documents and exported PDFs.
Are there other PDF-friendly alternatives to developer checkboxes?
Yes. Aside from using standard text symbols, you can use Data Validation to create a dropdown list containing a checkmark and a cross emoji. Since these are read as standard text by the spreadsheet, they will always render accurately during a PDF conversion.
