krunal123
Board Regular
- Joined
- Jun 26, 2020
- Messages
- 169
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Not exactly sure what you mean, but it sounds like you don't want to change your picture dimensions when resizing rows or columns. Quick way to do this is to right click the image, chart, etc. and select 'Format Picture'. I have Excel 2016 so it's the third option for me so I just select 'Don't move or size with cells' and problem solved. Hope this helps.
View attachment 25395
you can right click the point in the first screen shot and click on Format Cells. click the protection tab and make sure all cells are not locked. Screen shot 2-Then go to the review tab and click protect sheet. Make sure the only box with a check mark is Select Unlocked Cells. This will lock the photo and still let you use the cells.