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.