close

I want to create an inventory and have as the first cell in each row a
picture of the product. I would be able to click on it an enlarge the image
to see it.
The problem i am having is that every time i insert picture into excel it
covers all the cells.
I need some help with info on how to take a picture from my picture folder
in my documents and then send it directly to a single cell.
If possible plz detail
thx

Why don't you create a hyperlink to the picture, rather than place the image
in the spreadsheet. The user can click on the hyperlink to open the picture
for viewing.

To insert a hyperlink click INSERT on the menu and select HYPERLINK, or from
the keyboard press Ctrl K

--
Kevin Backmannquot;KostasHquot; wrote:

gt; I want to create an inventory and have as the first cell in each row a
gt; picture of the product. I would be able to click on it an enlarge the image
gt; to see it.
gt; The problem i am having is that every time i insert picture into excel it
gt; covers all the cells.
gt; I need some help with info on how to take a picture from my picture folder
gt; in my documents and then send it directly to a single cell.
gt; If possible plz detail
gt; thx

What I do is, instead of inserting the pictures in a cell, I insert them into
the Comment Box for each cell, then they pop-up, any size I want, as I mouse
over the cells...........

hth
Vaya con Dios,
Chuck, CABGx3
quot;KostasHquot; wrote:

gt; I want to create an inventory and have as the first cell in each row a
gt; picture of the product. I would be able to click on it an enlarge the image
gt; to see it.
gt; The problem i am having is that every time i insert picture into excel it
gt; covers all the cells.
gt; I need some help with info on how to take a picture from my picture folder
gt; in my documents and then send it directly to a single cell.
gt; If possible plz detail
gt; thx



quot;Kevin Bquot; wrote:

gt; Why don't you create a hyperlink to the picture, rather than place the image
gt; in the spreadsheet. The user can click on the hyperlink to open the picture
gt; for viewing.
gt;
gt; To insert a hyperlink click INSERT on the menu and select HYPERLINK, or from
gt; the keyboard press Ctrl K
gt;
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;KostasHquot; wrote:
gt;
gt; gt; I want to create an inventory and have as the first cell in each row a
gt; gt; picture of the product. I would be able to click on it an enlarge the image
gt; gt; to see it.
gt; gt; The problem i am having is that every time i insert picture into excel it
gt; gt; covers all the cells.
gt; gt; I need some help with info on how to take a picture from my picture folder
gt; gt; in my documents and then send it directly to a single cell.
gt; gt; If possible plz detail
gt; gt; thx

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()