Jun 29 2021 11:14 PM
On a mobile device I can use 'Insert'/'camera' in Excel to take photo and the image is inserted into the 'Worksheet' BUT it is floating on top of the cells. I want it 'inserted' into a cell.
My scenario -
Worksheet collects inventory details of machinery
Four columns - Item/Model/SerialNumber/Picture
I would like... click the corresponding cell - camera opens - take photo - image 'inserted' into cell.
Jun 30 2021 12:28 AM
SolutionPictures and shapes are always placed in a layer floating on top of cells. There is no way to insert a picture into a cell.
If you make sure that a picture is placed entirely within the borders of a cell, and if you specify 'Move with cells' or 'Move but don't size with cells', the picture will move with the cell if you sort the data.
Jun 30 2021 10:43 AM
Jun 30 2021 04:47 PM
Thank You for the reply
You have helped greatly.
As you have explained, Excel places Pics and Shapes on top of a 'Worksheet'; but from experience 'Tables' in WORD allow you to insert a Pic into a cell, and also has the 'Insert' / 'Camera' function. It places the Pic within the cell boarders which then needs to be 'anchored'.
Still some issues, but closer.
Jun 30 2021 12:28 AM
SolutionPictures and shapes are always placed in a layer floating on top of cells. There is no way to insert a picture into a cell.
If you make sure that a picture is placed entirely within the borders of a cell, and if you specify 'Move with cells' or 'Move but don't size with cells', the picture will move with the cell if you sort the data.