Another Way to Add Photo's

Another Way to Add Photo's

Ken Kash 1189628052|%e %b %Y, %H:%M %Z|agohover

Someone turned me on to a very simple solution that allows you display photos that are linked to cells by using the comments feature within excel.

In order to make this work effectively you'll need to go into the "Tools" menu and select "Options". On the "View" tab make sure that the "Comment indicator only" radio button is selected and then press OK.

Start by selecting the cell and add a Comment (with no text). After adding a Cell Comment, right click in the cell and choose Edit comment. Now double click the dotted outline of the Comment where the size handles are, and then click the "Colors and Lines" page tab. From this page click the drop arrow from the "Color" box and then "Fill Effects" and finally "Picture" then "Select Picture".

Re: Another Way to Add Photo's

Charles Magruder (guest) 1237215947|%e %b %Y, %H:%M %Z|agohover

This little tidbit is the most useful information I've received in 3 years. I had been hyperlinking photos to cells, but this way is a) faster and b) more efficient!!

Thank you

PS: I am changing every hyperlinked cell today!!

Re: Another Way to Add Photo's

Ken Kash 1237241088|%e %b %Y, %H:%M %Z|agohover

Careful…the excel file may get big quick. But considering how powerful computers are today (lots of ram, processing power and huge hard drives) it may not be an issue.