software

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?


quot;Heather Hquot; lt;Heather gt; wrote in message
...
gt;I have to email a spreadsheet that I made to a co-worker but each time I
gt;do,
gt; when he receives it, the margins change. They show correctly on my
gt; computer
gt; but when he gets it goes from 2 to 3 pages. It's not convienent for him
gt; to
gt; 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 quot;Fit toquot;
option, make it 1 page wide by 2 pages tall. Excel will choose the right
amount of shrinkage to make this happen.
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!

quot;Doug Kanterquot; wrote:

gt;
gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt; ...
gt; gt;I have to email a spreadsheet that I made to a co-worker but each time I
gt; gt;do,
gt; gt; when he receives it, the margins change. They show correctly on my
gt; gt; computer
gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent for him
gt; gt; to
gt; gt; change the margins each time he recieves them. What is going wrong?
gt;
gt; Various printers require a different amount of white space at the edge of
gt; the paper, so the number of pages will change at print time. If you don't
gt; think it will affect readability (much), and you MUST stay on two pages,
gt; click File, Page Setup, make sure you're on the Page tab. In the quot;Fit toquot;
gt; option, make it 1 page wide by 2 pages tall. Excel will choose the right
gt; amount of shrinkage to make this happen.
gt;
gt;
gt;

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.quot;Heather Hquot; gt; wrote in message
...
gt; Thanks Doug, but that doesn't seem to be the issue. What's happening is I
gt; have gone in and set my margins under page setup. Once I email it to
gt; someone
gt; the margins default back to standard margin settings. Is this normal?
gt; I've
gt; not encountered this problem before and it's driving me nuts!
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt;
gt;gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt;gt; ...
gt;gt; gt;I have to email a spreadsheet that I made to a co-worker but each time I
gt;gt; gt;do,
gt;gt; gt; when he receives it, the margins change. They show correctly on my
gt;gt; gt; computer
gt;gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent for
gt;gt; gt; him
gt;gt; gt; to
gt;gt; gt; change the margins each time he recieves them. What is going wrong?
gt;gt;
gt;gt; Various printers require a different amount of white space at the edge of
gt;gt; the paper, so the number of pages will change at print time. If you don't
gt;gt; think it will affect readability (much), and you MUST stay on two pages,
gt;gt; click File, Page Setup, make sure you're on the Page tab. In the quot;Fit toquot;
gt;gt; option, make it 1 page wide by 2 pages tall. Excel will choose the right
gt;gt; amount of shrinkage to make this happen.
gt;gt;
gt;gt;
gt;gt;
I wish you did too. I can't figure this out at all. I don't know why when
you email a doc the formats wouldn't stay with it. I don't know if this is a
quot;problemquot; or if it's normal. If you think of something, let me know. It's
causing major havoc around here.

quot;Doug Kanterquot; wrote:

gt; Hmmm.....that *is* odd. Or, maybe not. 99% of the sheets I create use the
gt; option I mentioned to you, because when I send them to my home office, the
gt; people there are too clueless to deal with print-invoked margin changes. I
gt; wish I had a 2nd machine set up here so I could try and reproduce what
gt; you're experiencing.
gt;
gt;
gt; quot;Heather Hquot; gt; wrote in message
gt; ...
gt; gt; Thanks Doug, but that doesn't seem to be the issue. What's happening is I
gt; gt; have gone in and set my margins under page setup. Once I email it to
gt; gt; someone
gt; gt; the margins default back to standard margin settings. Is this normal?
gt; gt; I've
gt; gt; not encountered this problem before and it's driving me nuts!
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have to email a spreadsheet that I made to a co-worker but each time I
gt; gt;gt; gt;do,
gt; gt;gt; gt; when he receives it, the margins change. They show correctly on my
gt; gt;gt; gt; computer
gt; gt;gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent for
gt; gt;gt; gt; him
gt; gt;gt; gt; to
gt; gt;gt; gt; change the margins each time he recieves them. What is going wrong?
gt; gt;gt;
gt; gt;gt; Various printers require a different amount of white space at the edge of
gt; gt;gt; the paper, so the number of pages will change at print time. If you don't
gt; gt;gt; think it will affect readability (much), and you MUST stay on two pages,
gt; gt;gt; click File, Page Setup, make sure you're on the Page tab. In the quot;Fit toquot;
gt; gt;gt; option, make it 1 page wide by 2 pages tall. Excel will choose the right
gt; gt;gt; amount of shrinkage to make this happen.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

While we're wondering about this, how about this:

1) Record a macro as you change the margins.
2) Put a custom button on the sheet, attached to the macro.
3) Format the button so it doesn't print.

Oooh....slick! It'll make fixing the margins into a one-click deal. Just be
sure that when recording the macro, you set the margins by typing in the
numbers, not by dragging the margins in print preview.

This would really put the quot;Kquot; in quot;Kustomquot;!

quot;Heather Hquot; gt; wrote in message
...
gt;I wish you did too. I can't figure this out at all. I don't know why when
gt; you email a doc the formats wouldn't stay with it. I don't know if this
gt; is a
gt; quot;problemquot; or if it's normal. If you think of something, let me know.
gt; It's
gt; causing major havoc around here.
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; Hmmm.....that *is* odd. Or, maybe not. 99% of the sheets I create use the
gt;gt; option I mentioned to you, because when I send them to my home office,
gt;gt; the
gt;gt; people there are too clueless to deal with print-invoked margin changes.
gt;gt; I
gt;gt; wish I had a 2nd machine set up here so I could try and reproduce what
gt;gt; you're experiencing.
gt;gt;
gt;gt;
gt;gt; quot;Heather Hquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks Doug, but that doesn't seem to be the issue. What's happening
gt;gt; gt; is I
gt;gt; gt; have gone in and set my margins under page setup. Once I email it to
gt;gt; gt; someone
gt;gt; gt; the margins default back to standard margin settings. Is this normal?
gt;gt; gt; I've
gt;gt; gt; not encountered this problem before and it's driving me nuts!
gt;gt; gt;
gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have to email a spreadsheet that I made to a co-worker but each
gt;gt; gt;gt; gt;time I
gt;gt; gt;gt; gt;do,
gt;gt; gt;gt; gt; when he receives it, the margins change. They show correctly on my
gt;gt; gt;gt; gt; computer
gt;gt; gt;gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent for
gt;gt; gt;gt; gt; him
gt;gt; gt;gt; gt; to
gt;gt; gt;gt; gt; change the margins each time he recieves them. What is going wrong?
gt;gt; gt;gt;
gt;gt; gt;gt; Various printers require a different amount of white space at the edge
gt;gt; gt;gt; of
gt;gt; gt;gt; the paper, so the number of pages will change at print time. If you
gt;gt; gt;gt; don't
gt;gt; gt;gt; think it will affect readability (much), and you MUST stay on two
gt;gt; gt;gt; pages,
gt;gt; gt;gt; click File, Page Setup, make sure you're on the Page tab. In the quot;Fit
gt;gt; gt;gt; toquot;
gt;gt; gt;gt; option, make it 1 page wide by 2 pages tall. Excel will choose the
gt;gt; gt;gt; right
gt;gt; gt;gt; amount of shrinkage to make this happen.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Your funny! I'll do this for a quick fix but I still need to figure out
what's going on with the spreadsheet. I don't think it should be doing this.
Thanks again and I'll keep checking to see if your able to figure out why my
spreadsheet is possessed!

quot;Doug Kanterquot; wrote:

gt; While we're wondering about this, how about this:
gt;
gt; 1) Record a macro as you change the margins.
gt; 2) Put a custom button on the sheet, attached to the macro.
gt; 3) Format the button so it doesn't print.
gt;
gt; Oooh....slick! It'll make fixing the margins into a one-click deal. Just be
gt; sure that when recording the macro, you set the margins by typing in the
gt; numbers, not by dragging the margins in print preview.
gt;
gt; This would really put the quot;Kquot; in quot;Kustomquot;!
gt;
gt; quot;Heather Hquot; gt; wrote in message
gt; ...
gt; gt;I wish you did too. I can't figure this out at all. I don't know why when
gt; gt; you email a doc the formats wouldn't stay with it. I don't know if this
gt; gt; is a
gt; gt; quot;problemquot; or if it's normal. If you think of something, let me know.
gt; gt; It's
gt; gt; causing major havoc around here.
gt; gt;
gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;
gt; gt;gt; Hmmm.....that *is* odd. Or, maybe not. 99% of the sheets I create use the
gt; gt;gt; option I mentioned to you, because when I send them to my home office,
gt; gt;gt; the
gt; gt;gt; people there are too clueless to deal with print-invoked margin changes.
gt; gt;gt; I
gt; gt;gt; wish I had a 2nd machine set up here so I could try and reproduce what
gt; gt;gt; you're experiencing.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Heather Hquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Thanks Doug, but that doesn't seem to be the issue. What's happening
gt; gt;gt; gt; is I
gt; gt;gt; gt; have gone in and set my margins under page setup. Once I email it to
gt; gt;gt; gt; someone
gt; gt;gt; gt; the margins default back to standard margin settings. Is this normal?
gt; gt;gt; gt; I've
gt; gt;gt; gt; not encountered this problem before and it's driving me nuts!
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Doug Kanterquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I have to email a spreadsheet that I made to a co-worker but each
gt; gt;gt; gt;gt; gt;time I
gt; gt;gt; gt;gt; gt;do,
gt; gt;gt; gt;gt; gt; when he receives it, the margins change. They show correctly on my
gt; gt;gt; gt;gt; gt; computer
gt; gt;gt; gt;gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent for
gt; gt;gt; gt;gt; gt; him
gt; gt;gt; gt;gt; gt; to
gt; gt;gt; gt;gt; gt; change the margins each time he recieves them. What is going wrong?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Various printers require a different amount of white space at the edge
gt; gt;gt; gt;gt; of
gt; gt;gt; gt;gt; the paper, so the number of pages will change at print time. If you
gt; gt;gt; gt;gt; don't
gt; gt;gt; gt;gt; think it will affect readability (much), and you MUST stay on two
gt; gt;gt; gt;gt; pages,
gt; gt;gt; gt;gt; click File, Page Setup, make sure you're on the Page tab. In the quot;Fit
gt; gt;gt; gt;gt; toquot;
gt; gt;gt; gt;gt; option, make it 1 page wide by 2 pages tall. Excel will choose the
gt; gt;gt; gt;gt; right
gt; gt;gt; gt;gt; amount of shrinkage to make this happen.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

By way of experiment, you could grab an XP installation CD and install an
older model printer (older because the CD has drivers for them. For newer
models, you usually need the CD that comes with the printer). Try installing
an HP OfficeJet 300, for instance. Make sure your normal printer is set as
the default. Email yourself a copy of the spreadsheet. Now, set the newly
installed printer as the default (and we're hoping it requires different
margins than your usual machine). Reboot the computer, check your email,
open the spreadsheet, and see if the margins have changed.quot;Heather Hquot; gt; wrote in message
news
gt; Your funny! I'll do this for a quick fix but I still need to figure out
gt; what's going on with the spreadsheet. I don't think it should be doing
gt; this.
gt; Thanks again and I'll keep checking to see if your able to figure out why
gt; my
gt; spreadsheet is possessed!
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt;gt; While we're wondering about this, how about this:
gt;gt;
gt;gt; 1) Record a macro as you change the margins.
gt;gt; 2) Put a custom button on the sheet, attached to the macro.
gt;gt; 3) Format the button so it doesn't print.
gt;gt;
gt;gt; Oooh....slick! It'll make fixing the margins into a one-click deal. Just
gt;gt; be
gt;gt; sure that when recording the macro, you set the margins by typing in the
gt;gt; numbers, not by dragging the margins in print preview.
gt;gt;
gt;gt; This would really put the quot;Kquot; in quot;Kustomquot;!
gt;gt;
gt;gt; quot;Heather Hquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I wish you did too. I can't figure this out at all. I don't know why
gt;gt; gt;when
gt;gt; gt; you email a doc the formats wouldn't stay with it. I don't know if
gt;gt; gt; this
gt;gt; gt; is a
gt;gt; gt; quot;problemquot; or if it's normal. If you think of something, let me know.
gt;gt; gt; It's
gt;gt; gt; causing major havoc around here.
gt;gt; gt;
gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hmmm.....that *is* odd. Or, maybe not. 99% of the sheets I create use
gt;gt; gt;gt; the
gt;gt; gt;gt; option I mentioned to you, because when I send them to my home office,
gt;gt; gt;gt; the
gt;gt; gt;gt; people there are too clueless to deal with print-invoked margin
gt;gt; gt;gt; changes.
gt;gt; gt;gt; I
gt;gt; gt;gt; wish I had a 2nd machine set up here so I could try and reproduce what
gt;gt; gt;gt; you're experiencing.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Heather Hquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Thanks Doug, but that doesn't seem to be the issue. What's
gt;gt; gt;gt; gt; happening
gt;gt; gt;gt; gt; is I
gt;gt; gt;gt; gt; have gone in and set my margins under page setup. Once I email it
gt;gt; gt;gt; gt; to
gt;gt; gt;gt; gt; someone
gt;gt; gt;gt; gt; the margins default back to standard margin settings. Is this
gt;gt; gt;gt; gt; normal?
gt;gt; gt;gt; gt; I've
gt;gt; gt;gt; gt; not encountered this problem before and it's driving me nuts!
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Doug Kanterquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;Heather Hquot; lt;Heather gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;I have to email a spreadsheet that I made to a co-worker but each
gt;gt; gt;gt; gt;gt; gt;time I
gt;gt; gt;gt; gt;gt; gt;do,
gt;gt; gt;gt; gt;gt; gt; when he receives it, the margins change. They show correctly on
gt;gt; gt;gt; gt;gt; gt; my
gt;gt; gt;gt; gt;gt; gt; computer
gt;gt; gt;gt; gt;gt; gt; but when he gets it goes from 2 to 3 pages. It's not convienent
gt;gt; gt;gt; gt;gt; gt; for
gt;gt; gt;gt; gt;gt; gt; him
gt;gt; gt;gt; gt;gt; gt; to
gt;gt; gt;gt; gt;gt; gt; change the margins each time he recieves them. What is going
gt;gt; gt;gt; gt;gt; gt; wrong?
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Various printers require a different amount of white space at the
gt;gt; gt;gt; gt;gt; edge
gt;gt; gt;gt; gt;gt; of
gt;gt; gt;gt; gt;gt; the paper, so the number of pages will change at print time. If you
gt;gt; gt;gt; gt;gt; don't
gt;gt; gt;gt; gt;gt; think it will affect readability (much), and you MUST stay on two
gt;gt; gt;gt; gt;gt; pages,
gt;gt; gt;gt; gt;gt; click File, Page Setup, make sure you're on the Page tab. In the
gt;gt; gt;gt; gt;gt; quot;Fit
gt;gt; gt;gt; gt;gt; toquot;
gt;gt; gt;gt; gt;gt; option, make it 1 page wide by 2 pages tall. Excel will choose the
gt;gt; gt;gt; gt;gt; right
gt;gt; gt;gt; gt;gt; amount of shrinkage to make this happen.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;