MS Excel Help

MagicToaster

I’m making a form in Excel that has a series of check boxes. Originally, I drew the checkboxes next to the text by using the draw tool. Most of the time the text and the boxes behave:



However, when I print a lot of the boxes move around:



Is there a way to integrate a box inline with the text? Is there any other way to draw a box that won’t move around? Mind you, an inline solution would be better because I’ve noticed that the text in Excel doesn’t render the same way on screen as it does on the printed page. It tends to stretch, causing words at the end of sentences to roll to the beginning of the following text line mismatching words and boxes.

But inline or not, I’ll take what I can get.

TychoCelchuuu

This thing:

□

might work, as long as you change the font size to whatever you need it to be.

MagicToaster

I tried that, but changing the font size will also change the line spacing.

Fallingman

rather than drawing a box, can you use cell borders?

MagicToaster

Not really, because of the way the form is constructed.

whuppins

You know that there's an actual checkbox control in Excel, right? Add "control toolbox" to your toolbar, click the Check Box button, and draw it. You can size it and move it, and it has its own Caption property (right-click it from within Design Mode to get to its properties) so you don't have to lay out the box and the text separately. There's even an option to lock it down to the cell it's sitting on top of so that it moves and/or resizes when you move and resize the cell.

Edit: Looking again at your example, it looks like you're using a really small font size. When you go below 7-point or so, Office apps will usually switch to Small Fonts to represent your text, even if it's, say, Times New Roman. If this is the case, that may explain why the text on your screen doesn't match up with the text on your printed pages: They're each using a different font.

MagicToaster

whuppins wrote: »

When you go below 7-point or so, Office apps will usually switch to Small Fonts to represent your text, even if it's, say, Times New Roman. If this is the case, that may explain why the text on your screen doesn't match up with the text on your printed pages: They're each using a different font.

By the way the printer rendered my text, I figured it was using a diferent font or font size. You've just confirmed my suspicion and told me why. Thanks dude!