#1   Report Post  
Posted to microsoft.public.excel.misc
sdmccabe
 
Posts: n/a
Default Margins

I have a sheet setup to print on legal size paper with plenty of room to add
new columns to the right, however noting I do to reset margin (right) will
allow the additional columns to print on one page. What am I missing?
  #2   Report Post  
Posted to microsoft.public.excel.misc
akhilash
 
Posts: n/a
Default Margins

Possibility : Clear Print area
Go to the "File" menu, look for "Print Area option" and under this option
look for Clear Print area. This should clear the earlier selection.
Hope this is helpful

"sdmccabe" wrote:

I have a sheet setup to print on legal size paper with plenty of room to add
new columns to the right, however noting I do to reset margin (right) will
allow the additional columns to print on one page. What am I missing?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Search33
 
Posts: n/a
Default Margins

Hello sd,
Make sure that your print area is set correctly. Then go into
file-pagesetup and set the fit to to 1 page wide by "blank" (clear this
field) tall

- Search

"sdmccabe" wrote:

I have a sheet setup to print on legal size paper with plenty of room to add
new columns to the right, however noting I do to reset margin (right) will
allow the additional columns to print on one page. What am I missing?

  #4   Report Post  
Posted to microsoft.public.excel.misc
sdmccabe
 
Posts: n/a
Default Margins

That did it -thanks.

"akhilash" wrote:

Possibility : Clear Print area
Go to the "File" menu, look for "Print Area option" and under this option
look for Clear Print area. This should clear the earlier selection.
Hope this is helpful

"sdmccabe" wrote:

I have a sheet setup to print on legal size paper with plenty of room to add
new columns to the right, however noting I do to reset margin (right) will
allow the additional columns to print on one page. What am I missing?

  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Margins

"sdmccabe" wrote in message
...
I have a sheet setup to print on legal size paper with plenty of room to

add
new columns to the right, however noting I do to reset margin (right) will
allow the additional columns to print on one page. What am I missing?


Page Setup/ Page tab/ Fit to 1 page wide.
--
David Biddulph


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 2003 - Footer Left/Right Margins Laura J Excel Discussion (Misc queries) 3 October 4th 05 10:46 PM
Alternating Margins michaelgrant Excel Discussion (Misc queries) 2 September 13th 05 08:03 PM
No Margins [email protected] Excel Discussion (Misc queries) 1 August 18th 05 02:46 AM
If I change page margins headers don't line up??? CGINUSA Excel Discussion (Misc queries) 2 June 25th 05 12:54 PM
xl Headers and Footers always use 3/4 inch side margins??? mr unreliable New Users to Excel 1 February 14th 05 07:55 PM


All times are GMT +1. The time now is 11:41 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"