how can I insert jpeg file in the cell?

  • Thread starter Thread starter Kiknadze Lado
  • Start date Start date
K

Kiknadze Lado

Dear All,

I have excel sheet with columns:

RefNo, Account, Project, Amount, Receipt

In the column "Receipt" I would like to insert image or link cell to image
file (it is jpeg format file). If I click cells e1, e2, e3 ... I want to
appear appropriated pictures. How can I do this?
How can I insert picture (in one cell) and how can I get it when I need to
see it in normal size?

Thank you in advance.
Lado
 
Select the cell where you want the picture
Turn on the macro recorder and then do Insert=>Picture=>From File and select
you file.

This should give you the basic code to start with.
 
Hi Tom,

Thank you for your answer. I did so as you told me but I could only to
insert picture in the Activesheet and not in the selected cell. Let me know
how to insert picture in the cell.

Best wishes,
Lado
 
You can't insert a picture in a cell. A cell can only hold a number or a
text string. You can position the picture over the cell.
 
Back
Top