how to cause Excel 2011 table cell to automatically expand to match size of an inserted image
Posted on 2015-02-03
Using Excel 2011:
I have a workbook in which one worksheet is used to store images of expense receipts.
When receipts are copied into the worksheet, their image sits on top of the cells.
For example, if I want to insert, say a 4" x 6" image into cell C3, instead of cell C3 expanding to accommodate the inserted image, it remains at it's original size and the image overlays, say, range c3:z50 (coordinates are just an example)
How can I insert an image and have the cell expand automatically?