Thread: Margin Trouble
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Margin Trouble

Hmmm.....that *is* odd. Or, maybe not. 99% of the sheets I create use the
option I mentioned to you, because when I send them to my home office, the
people there are too clueless to deal with print-invoked margin changes. I
wish I had a 2nd machine set up here so I could try and reproduce what
you're experiencing.


"Heather H" wrote in message
...
Thanks Doug, but that doesn't seem to be the issue. What's happening is I
have gone in and set my margins under page setup. Once I email it to
someone
the margins default back to standard margin settings. Is this normal?
I've
not encountered this problem before and it's driving me nuts!

"Doug Kanter" wrote:


"Heather H" <Heather wrote in message
...
I have to email a spreadsheet that I made to a co-worker but each time I
do,
when he receives it, the margins change. They show correctly on my
computer
but when he gets it goes from 2 to 3 pages. It's not convienent for
him
to
change the margins each time he recieves them. What is going wrong?


Various printers require a different amount of white space at the edge of
the paper, so the number of pages will change at print time. If you don't
think it will affect readability (much), and you MUST stay on two pages,
click File, Page Setup, make sure you're on the Page tab. In the "Fit to"
option, make it 1 page wide by 2 pages tall. Excel will choose the right
amount of shrinkage to make this happen.