labels and text boxes move during printing

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
I have a bunch of labels and text boxes in Row 1. I have them locked so they do not move when columns are resized. But when the worksheet is printed, they get all jumbled up...not just on the printed page, but in the actual worksheet as well. What can I do to prevent this?

Thanks!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
Oddly (?), if I just select a print area from within the other rows, and print that, there isn't a problem...
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
Maybe I need to anchor all the text boxes and labels to a form? But it would have to be a form that was always present, even when data was being entered into other parts of the worksheet (i.e. it would have to be non-modal). Is that possible?
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web

ADVERTISEMENT

Other than the link Kristy provided, I know of no other solution. So my addition to this thread will be shaped as a question then.

To someone with Excel v11 (2003): Does this also happen in said version?

I only have 2000 and 2002 to test. So I'm curious if this was fixed in 2003 or not. Just curious mainly. :)
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
Von Pookie, thanks for the referal, but it doesn't help. I don't have service pack 3 installed, and I have to have my controls set to 'don't move or size with cells,' because the users often resize the columns and that in itself causes essentially the same problem.
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
I found that when you associate all the affected items together as a 'group' it pretty much takes care of the problem.
 

Forum statistics

Threads
1,147,510
Messages
5,741,574
Members
423,668
Latest member
Audorin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top