Question posted 2012 ยท +5 upvotes
I have been able to paste image in excel. but couldn’t insert the image into cell.
Can I insert an image in excel cell so that it fits there as thumbnail & can be stretched by dragging.
Accepted answer +6 upvotes
I would not go as far to say, that this is not possible, but there are limitations.
You can assign a picture to a cell.
Choose a picture through Insert-Tab -> Picture and insert it to a worksheet.
Now make your desired cell so big it could fit your thumbnail sized picture and resize your picture inside of excel.
Cut&Paste it into your cell, then select Size & Properties of this picture and go to properties. Watchout, that you don’t just link the picture (you can see the option with the small arrow besides the insert-button).
Here you can define how this picture is going to be adapted in size and position.
You want to select related to size & position of cell or something like that (having german verion of 2007, so sorry if not everything is to the point).
Other options would be related to cell-position or unrelated.
Now as I tested this, my demo picture could resize to a smaller size but not to a bigger, but once placed in a specific cell, it stayed there.
However, I am sure the insert-process could be optimized and even automized.
Here is an example, in which a picture gets resized through cell-size:


Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.