How to create an Image Placeholder in Excel Cell

[SOLTEC]

I have a spreadsheet I want to have my employees be able to click on and browse to images and add the image in the cell. How do I add an image placeholder, please?

Thank you in advance for any and all answers. It is greatly appreciated

 

[skillilea]

Are you trying to add a shape over top of the cell sized exactly the same as the cell height, width, length or make the image the background of the cell?

 

[SOLTEC]

What I want is a cell an employee can click on that has an IMAGE placeholder so they know where the image is to be saved in the workbook sheet and a folder dialog box opens to allow them to select an image to insert in the cell

 

[skillilea]

Do you have a picture or sample sheet to show what you are trying to accomplish?

 

[SOLTEC]

I have an inventory sheet with item numbers, descriptions, quantity, and I need my warehouse personnel to match the inventory items to pictures taken by my receiving team with a picture they take on checking the inventory in. The warehouse needs to be able to identify by the description, Item number, and an IMAGE

 

[skillilea]

365 has the IMAGE function will that work

Book1
	C	D	E	F	G
3	Id	Desc	Location		Image
4	1	Item	Bin 5
Sheet1

Cell Formulas
Range	Formula
G4	G4	=IMAGE("https://media.gettyimages.com/id/185407357/photo/mystery-can.jpg?s=1024x1024&w=gi&k=20&c=1JobjryTeiaYr_j6wwGphPG8_EKt7Tkb3nnwCo8rTWA=")