What I have done is merge a large number of cells together to form one large cell for the purpose of adding pictures to the spreadsheet. However, some of the pictures are larger than the cell. What I would like to do it format the cell somehow so that any picture placed within it will auto resize to fit within the cell. Ideally, it should be easy for the user to add a picture into the cell. In other words, it will not do if the use has to insert a picture, then go through the process of resizing it to fit the cell; the picture needs to automatically adjust in size when placed withing the given cell.

Any ideas? Much thanks