Posted By: Anonymous
I’m tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can get the pictures to “float” around my worksheet, but I need to put them into a cell. How can I do this?
You can add the image into a comment.
Right-click cell > Insert Comment > right-click on shaded (grey area) on outside of comment box > Format Comment > Colors and Lines > Fill > Color > Fill Effects > Picture > (Browse to picture) > Click OK
Image will appear on hover over.
Microsoft Office 365 (2019) introduced new things called comments and renamed the old comments as “notes“. Therefore in the steps above do
New Note instead of
Insert Comment. All other steps remain the same and the functionality still exists.
There is also a $20 product for Windows – Excel Image Assistant…