Forum Discussion
Freezeing photos to excel workbook
I have a file in excel that I need help with. I have a lot of items in my collection (2237 Items) and have pasted a photo of each item in a seperate cell in the workbook. When I go from top to bott...
Hi, Thanks for getting back to me. When I add photos to my cells, here is what I do.
1. Click on cell.
2. Click on insert.
3. Click on picture.
4. Click on this device.
5. Find photo and double click on it.
6. Photo appears in cell.
7. Adjust photo to fit cell.
8. RMBC on photo.
9. Click on Size & Properties.
10. Go down to Properties/Move & size with cells, then check Locked.
In the passed this has worked. Just recently when I try to go from top to anywhere in workbook by the up & down arrows to the right of workbook some of the photos jump to different locations or just move one or two cells from where they are suppose to be.
I right clicked on the picture and went to format picture. On my version all that is there is Shadow, Reflection, Glow, Soft Edges, 3-D Format, 3-D Rotatio and Artistic Effects. I don't have a "Protect Sheet" on mine.
Is there any other way to add photos and freeze them to the cells? Still have to have capability to insert rows in the workbook and have all photos move with insert command.
Thanks, John
1. Click on cell.
2. Click on insert.
3. Click on picture.
4. Click on this device.
5. Find photo and double click on it.
6. Photo appears in cell.
7. Adjust photo to fit cell.
8. RMBC on photo.
9. Click on Size & Properties.
10. Go down to Properties/Move & size with cells, then check Locked.
In the passed this has worked. Just recently when I try to go from top to anywhere in workbook by the up & down arrows to the right of workbook some of the photos jump to different locations or just move one or two cells from where they are suppose to be.
I right clicked on the picture and went to format picture. On my version all that is there is Shadow, Reflection, Glow, Soft Edges, 3-D Format, 3-D Rotatio and Artistic Effects. I don't have a "Protect Sheet" on mine.
Is there any other way to add photos and freeze them to the cells? Still have to have capability to insert rows in the workbook and have all photos move with insert command.
Thanks, John
Hi John cardsfaninmo
To "Protect Sheet" you need to RMBC on the spreadsheet tab at the bottom.
This is really weird:
" Just recently when I try to go from top to anywhere in workbook by the up & down arrows to the right of workbook some of the photos jump to different locations or just move one or two cells from where they are suppose to be"
- I've attached a screenshot of what opens when I select "Format Picture". Do you get a window like that? Your version of Excel might be different. If it's the same check the same boxes such as "Don't move or size with cells"
- I've also attached a screenshot of where to find the "Protect Sheet" option
Cheers
Baz
- Thanks, Baz.
Will try these suggestions and see how it goes. One last question.
Do I have to do this "Format Picture" to each individual photo or is there a way to do it for the whole coloumn?
I tried to do the "Like" but it's not showing any likes. Thanks again.