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 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.
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.