Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default text boxes and shapes in excel 2007 move when printing

How do I keep text boxes and shapes in excel 2007 from moving when I click on
print preview or print the page? They move to the right about one inch when
I print. I tried to group and ungroup and that doesn't work. I also tried
to protect the worksheet but that didn't help either. Thanks for your help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default text boxes and shapes in excel 2007 move when printing

This was written for xl2002, but maybe it'll work with xl2007:

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002



Shawna wrote:

How do I keep text boxes and shapes in excel 2007 from moving when I click on
print preview or print the page? They move to the right about one inch when
I print. I tried to group and ungroup and that doesn't work. I also tried
to protect the worksheet but that didn't help either. Thanks for your help.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default text boxes and shapes in excel 2007 move when printing

I had tried that and it doesn't work. I have the whole worksheet set to
'move and size with cells'. Thanks.

"Dave Peterson" wrote:

This was written for xl2002, but maybe it'll work with xl2007:

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002



Shawna wrote:

How do I keep text boxes and shapes in excel 2007 from moving when I click on
print preview or print the page? They move to the right about one inch when
I print. I tried to group and ungroup and that doesn't work. I also tried
to protect the worksheet but that didn't help either. Thanks for your help.


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Text boxes & Graphics Matt Warden Excel Discussion (Misc queries) 2 May 3rd 07 05:44 PM
Formatting shapes with excel 2007 Bucky Excel Discussion (Misc queries) 0 March 8th 07 08:49 PM
Anchoring shapes when printing in Excel 2007 DLF Excel Discussion (Misc queries) 2 January 2nd 07 06:14 PM
excel 2007 beta text box printing Asterix Excel Discussion (Misc queries) 3 July 18th 06 05:32 PM
why do check boxes move when printing excel spreadhseets Simon Jefford Excel Discussion (Misc queries) 3 June 22nd 05 02:04 PM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"