Print out does not match spreadsheet

G

Guest

I have pasted a picture of text to a spreadsheet. The print area is exactly
the size of the picture. The margins are set very thin at .2 all sides. So
I expect the picture to fill the print page except the margins. But instead
there is over an inch of space between the top of the picture and the top
margin and the bottom of the picture and the bottom margin. How is this
possible if my picture takes up the entire print area on the spreadsheet?
 
G

Gord Dibben

Did you set the header and footer margins to 0?

Also, very few printers will allow no whitespace on a page.


Gord Dibben MS Excel MVP
 
G

Guest

Yes I tried 0 and .2. Please understand though, I'm not going for no white
space. My issue is that the picture does not touch the margin. For example
it could be a three inch margin, but I would still be getting an extra inch
between the margin and the picture. What is causing the space between the
margin and the picture? on the spreadsheet the picture is taking up the
entire print area, but not on the print preview and the printout.
 
G

Gord Dibben

Being one who rarely works with pictures in Excel that would take up a whole
page, I cannot even guess at what is causing the space between margin and
picture.

Sorry, Gord
 
G

Guest

I'm sure it sounds strange. Basically the first page is an excel form and
the second page is our Terms and Conditions. The Ts and Cs are basically a
full page of fine print, so I copied them from word and pasted as a picture
to make it easy to size the page full of word text to the room I had to work
with in the excel print area. If I've peaked your couriosity I could email
it to you? ; )

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top