Images Not Resizing in Excel 365.

I've moved my large business SS from excel 2007 to Excel365 (to work with my new win10 laptop). My SS is to manage artworks, and has 100's of images in a worksheet along with data. What I am experiencing is;

I 'select' an area of cells that includes an image and data, I go to the worksheet I want to paste it into, select the location and 'paste'.

Usually, in excel'07 the copied cells are pasted straight in and the image automatically fits the space (the cells are smaller in the target worksheet).

However, in this excel365 I paste the contents and the image stays large, ie. it doesn't automatically shrink to fit the space?

Any help much appreciated.

Hi thanks for reply.

For many years I've been selecting/copying and area of cells containing an image plus info (excel'07). I paste it onto a 'sales sheet' worksheet with same format but cell size sizes are smaller (I've now realised). It's always worked fine until now. I realise that until now the excel has been reducing the size of the pasted image to fit the area.

Now it isn't reducing the image size so it it twice as big and overlaps (in excel365). A real pain tbh.

Many thanks for any suggestions.