Spreadsheet resizes my images?

[JKlarsen]

I have a fairly large spreadsheet which has a lot of images in it.
And i have noticed that whenever i insert or delete rows it squashes or stretches the image, which it shouldn't do.
So i end up using alot of time for manually rescaling the images.

Any tips or tricks etc. ?

Kind regards...Jan

[jgd]

Click on your image to select it, then right-click or Ctrl-click to open the context menu. Choose Anchor > To Page instead of To Cell which is the default option. Then your images will not be distorted.

Jacqueline

[jklarsen]

Hi,

and thanks for the swift reply.


I works.
But now the images doesnt follow the cell (obviously) anymore, which means that i still have to manually move them up or down.

Isn't it possible to have the image anchored to a cell (default) and insert or delete cells without the image being resized (squashed/strethed) and loosing the ratio aspect.


Kind regards...Jan

[jgd]

I think it's possible
Keep the default option Anchor > To Cell.
Click on the image, then Ctrl-click, and in the context menu click on "Position and Size". In the "Protect" section check "Position", the check box Size will be automatically marked. Click OK.

Jacqueline