Checkbox Allignment Problems

Question

I use an Excel spreadsheet as a form which can be emailed to clients. My form has lots of checkboxes in it and when I'm filling in the form, everything aligns perfectly. But as soon as I print the form or convert it to a PDF to email to a client, the alignment is all over the place. The text that goes with each checkbox remains in the correct position, but the checkbox itself shifts about 1cm to the left and sometimes covers up text to the left. How can I rectify this problem?

Answer 1

In File > Page Setup. On the Page tab, click the Options button

Choose Format For Any Printer

---

Now check the positions of your buttons. Unfortunately, Move and Size with cells is not available for the checkbox control.****

Answer 2

It most certainly would. It is the printer driver in conjunction with the OS that does the PDF conversion.

Answer 3

Thanks Bob,

I have been using the text in the checkboxes, so that isn't the problem. When I mainly have the problem is when I convert the spreadsheet to a PDF. 99% of the time I only email quotes. Would out of date printer drivers effect the format when I am simply converting to PDF?

Thank you in advance.

Answer 4

A couple of things: make sure your print driver is fully upto date; use text in the check box itself, not in an adjacent cell