Images Not Resizing in Excel 365.

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.

  • You can try to use Copy as Picture.

    I'm not sure if this is relevant

    An embedded image is resized when you paste it to another location in an Excel 2010 workbook

  • 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.

  • 1. Select your specific object which you want to prevent from resizing or moving, and click Format in the ribbon, then click button in the Size group, see screenshot: 2. In the popped out pane, click Size & Properties icon, and check Don’t move or size with cells option under PROPERTIES section.

    J wick

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!