Image distortion during printing and preview

C

canology

I have been inserting jpg images into Excel and while they look fine while I
am in the actual worksheet, the images get stretched to a small but noticable
degree when I see them in Print Preview (or actually print them). The images
have had the aspect ratio locked. I am using Excel 2000.

Any ideas on this?
 
S

smartin

canology said:
I have been inserting jpg images into Excel and while they look fine while I
am in the actual worksheet, the images get stretched to a small but noticable
degree when I see them in Print Preview (or actually print them). The images
have had the aspect ratio locked. I am using Excel 2000.

Any ideas on this?

Just a couple thoughts.

Is the page itself being distorted when printing (i.e., by the print
setup options to keep output contained to x pages wide/tall)?

Try setting the image properties (right click) so it does not resize
with cells.
 
C

canology

smartin said:
Just a couple thoughts.

Is the page itself being distorted when printing (i.e., by the print
setup options to keep output contained to x pages wide/tall)?

Try setting the image properties (right click) so it does not resize
with cells.

It doesn't *look* like the whole page is resizing (I can only tell the
images are distorted because they are pictures of faces, so they look broader
than normal). The pages are easily able to fit on one page. Does Excel
stretch the print area to fit the page?

The images are set to not resize with cells, still they are slightly
stretched.

I appreciate the time you took to reply, thanks!
 
C

canology

smartin said:
Just a couple thoughts.

Is the page itself being distorted when printing (i.e., by the print
setup options to keep output contained to x pages wide/tall)?

Try setting the image properties (right click) so it does not resize
with cells.

It doesn't *look* like the whole page is resizing (I can only tell the
images are distorted because they are pictures of faces, so they look broader
than normal). The pages are easily able to fit on one page. Does Excel
stretch the print area to fit the page?

The images are set to not resize with cells, still they are slightly
stretched.

I appreciate the time you took to reply, thanks!
 
S

smartin

canology said:
It doesn't *look* like the whole page is resizing (I can only tell the
images are distorted because they are pictures of faces, so they look broader
than normal). The pages are easily able to fit on one page. Does Excel
stretch the print area to fit the page?

The images are set to not resize with cells, still they are slightly
stretched.

I appreciate the time you took to reply, thanks!

AFAIK, Excel doesn't stretch the output as long as File | Page Setup |
Page | Adjust to | is selected (whereas | Fit to | would be another story).

You already checked the aspect ratio... which I overlooked in my
reply... good job for that.

Only other thought is the printer driver is doing something mischievous.

FWIW I have noticed varying results with different image types in Excel.
You could try substituting the original graphic with a BMP, PNG, or
GIF version of the same.
 
C

canology

Darn

It must be something else (like the printer driver, as you suggested). I
tried converting the images to png's, gif's and bmp's and nothing was
different.

Oh well, I appreciate you trying!
 
R

Roger Camp

Canlogy, I had this problem before, this seem to work in early versions of
excel, but not in 2007. Here is how I solved the issue:
1) Click on the image.
2) Hold down Shift and go to the Edit menu, then select Copy Picture.
3) Hit Paste.

I hope this helps.

Roger.
 

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