How to lock a picture in Microsoft Excel

In this tutorial, we will learn how to lock a picture in Microsoft Excel. To lock a picture in Microsoft Excel, we can utilize the “Locked” option in the properties section of the “Format Picture” pane and the “Protect Sheet” option.

Locking a picture in Microsoft Excel involves preventing unintentional movement or resizing of an image within a worksheet. By locking a picture, it is set in a fixed position, ensuring that accidental dragging or resizing is avoided while interacting with the worksheet.

Step 1 – Select the Complete Sheet

– Select the complete sheet by pressing CTRL+A or utilizing the triangle at the upper left corner of the sheet.

Step 2 – In the Format Cells Dialog Box Uncheck the Box with the Locked Option

– Press CTRL+1 to open the “Format Cells” dialog box.
– In the “Protection” tab, uncheck the box with the “Lableld” option.

Step 3 – Perform a Right-click on the Picture

– Perform a right-click on the picture.
– The context menu will appear.

Step 4 – Choose the “Size and Properties” Option

– Choose the “Size and Properties” option in the context menu.
– The “Format Picture” pane will open.

Step 5 – Check the Following Checkboxes

– In the “Size” section check the box next to the “Lock aspect ratio” option.
– Now, check the box next to the option labeled “Locked” in the “Properties” section.

Step 6 – Now Protect the Sheet

– Locate the Review tab in the menu bar.
– Perform a click on the “Protect Sheet” option.
– Set a password and “Protect” the sheet.

Step 7 – Now Check if the Picture is Locked

– Now check the picture is locked.
– The picture will not get selected and neither it can be resized.