Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-1419933%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419933%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%20how%20do%20I%20lock%20an%20image%20in%20a%20cell%20so%20that%20it%20does%20not%20move%20when%20I%20insert%20a%20new%20row%3F%26nbsp%3B%20Thank%20you%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1419933%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420066%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680790%22%20target%3D%22_blank%22%3E%40LydiaMars%3C%2FA%3E%26nbsp%3BWhen%20you%20say%20that%20the%20picture%20should%20NOT%20move%20when%20you%20insert%20a%20new%20row%2C%20you%20need%20to%20format%20the%20picture%20%22Don't%20move%20or%20size%20with%20cells%22.%20This%20will%20%22fix%22%20the%20picture's%20position%20in%20the%20sheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-05-27%20at%2012.01.39.png%22%20style%3D%22width%3A%20202px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194720i9D5106DAEE132B47%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-05-27%20at%2012.01.39.png%22%20alt%3D%22Screenshot%202020-05-27%20at%2012.01.39.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Good day, how do I lock an image in a cell so that it does not move when I insert a new row?  Thank you

 

 

 

 

3 Replies
Highlighted

@LydiaMars When you say that the picture should NOT move when you insert a new row, you need to format the picture "Don't move or size with cells". This will "fix" the picture's position in the sheet.

Screenshot 2020-05-27 at 12.01.39.png

Highlighted

@Riny_van_Eekelen 

 

Thank you Riny I have tried that but it still moves.  I do not know if there is maybe some other formatting on my sheet that is causing this problem. 

Highlighted

@LydiaMars Can you upload an example (or some screenshots) to demonstrate the problem?