1

I have two spreadsheets with different row heights and cell widths. When I copy rows from spreadsheet #1 to spreadsheet #2 the images get distorted in an inconsistent manner (some end up just a few pixels high, some are correct and some are adjusted to fit the width of the cells in spreadsheet #2).

Is there a way to make the images paste undistorted?

1 Answer 1

3

There are several ways Excel handles the resizing of rows and columns that are located under a picture. Micorsoft has a short article about this phenomenon, know as "Object positioning properties". Long story short: check the properties of your images (right click, select "Properties.." and select "Properties" on the left side of the window), and set it to "Don't move or size with cells" before copying and you should be good to go.

Image object properties in Excel

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .