Worksheet design

[dave8]

I'm designing a worksheet by adding some textboxes, labels, symbols. Looks good on the screen. But when I want to look at it using Print Preview, my worksheet seems out of alignment. That is, the textboxes don't line up with the textbox beneath it. It does on the screen but not in Print Preview, the controls are mis-aligned. How to adjust this so that the screen and Print Preview is the same?

 

[Robert Mika]

I'm designing a worksheet by adding some textboxes, labels, symbols. Looks good on the screen. But when I want to look at it using Print Preview, my worksheet seems out of alignment. That is, the textboxes don't line up with the textbox beneath it. It does on the screen but not in Print Preview, the controls are mis-aligned. How to adjust this so that the screen and Print Preview is the same?

Have you tried to print your sheet?
The Print Preview may skew some of your objects.
Is your Print Area set up correctly and have you locked your object to move and size with the cell?

 

[dave8]

Have you tried to print your sheet?
The Print Preview may skew some of your objects.
Is your Print Area set up correctly and have you locked your object to move and size with the cell?

The Print Area is set up correctly to fit on a single page and the Textbox lock property is set to True. But when I print the worksheet, one of the Textbox is larger and extends over to the Textbox next to it. How to I keep it in place?