ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Help with pictures plzzz (https://www.excelbanter.com/excel-discussion-misc-queries/81374-excel-help-pictures-plzzz.html)

KostasH

Excel Help with pictures plzzz
 
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

Kevin B

Excel Help with pictures plzzz
 
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 Backmann


"KostasH" wrote:

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


CLR

Excel Help with pictures plzzz
 
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



"KostasH" wrote:

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


KostasH

Excel Help with pictures plzzz
 


"Kevin B" wrote:

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 Backmann


"KostasH" wrote:

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



All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com