Forum Discussion

Donald_Locke's avatar
Donald_Locke
Copper Contributor
Sep 07, 2023

Lost checkbox print capability

I have a rectangle checkbox next to a product line item. The checkbox appears on print preview but posts a dot or period on the printed copy. Any suggestions?

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Donald_Locke 

    If you are experiencing issues with checkboxes not printing correctly in Excel, where they appear as dots or periods on the printed copy, there are a few troubleshooting steps you can follow to address this problem:

    1. Check the Checkbox Properties:
      • Right-click on the checkbox.
      • Select "Format Control" or "Edit Text" (the wording may vary depending on your version of Excel).
      • Ensure that the "Font" tab does not have any special formatting like a dot or period selected as the character to display in the checkbox. The "Character" field should be left blank or contain a typical checkbox character (like a checkmark).
    2. Check the Printer Settings:
      • Sometimes, printer settings can affect how checkboxes are printed. Make sure your printer driver is up-to-date.
      • Go to "File" > "Print" > "Printer Properties" (or similar options based on your Excel version and printer) and review the settings related to graphics and fonts. Ensure that you have the correct settings for printing checkboxes.
    3. Print to PDF:
      • If the issue persists with physical printing, try printing the worksheet to a PDF file instead. This can help determine if the issue is with your printer or Excel settings.
      • Use the "File" > "Print" > "Save as PDF" option in Excel to create a PDF file with the checkboxes.
    4. Check for Excel Updates:
      • Ensure that you have the latest updates and patches for your version of Excel. Sometimes, Microsoft releases updates that address printing issues.
    5. Try a Different Printer:
      • If possible, try printing the worksheet to a different printer to see if the issue persists. This can help determine if the problem is specific to your printer.
    6. Insert New Checkboxes:
      • If none of the above steps work, consider deleting the problematic checkboxes and inserting new ones. Sometimes, checkboxes can become corrupted, leading to printing issues.
    7. Worksheet Corruption: In rare cases, worksheet corruption can cause printing problems. If the issue persists, you might want to copy the data to a new worksheet and see if the problem persists there.
    8. Test on a Different Computer: If you have access to another computer with Excel, try opening and printing the same worksheet to see if the issue occurs there. This can help determine if the problem is specific to your computer or Excel installation.

    If none of these steps resolve the issue, it might be helpful to provide more details about your Excel version and printer model, as well as any specific settings you are using, so that further troubleshooting can be tailored to your setup. The text and steps were created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark them as helpful and like it!

    This will help all forum participants.

Resources