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.
![](https://spreadcheaters.com/wp-content/uploads/Step-7-Now-Check-if-the-Picture-is-Locked.gif)
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
![](https://spreadcheaters.com/wp-content/uploads/Step-1-Select-the-Complete-Sheet.png)
– 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
![](https://spreadcheaters.com/wp-content/uploads/Step-2-In-the-Format-Cells-Dialog-Box-Uncheck-the-Box-with-the-Locked-Option.gif)
– 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
![](https://spreadcheaters.com/wp-content/uploads/Step-3-Perform-a-Right-click-on-the-Picture-Copy.png)
– Perform a right-click on the picture.
– The context menu will appear.
Step 4 – Choose the “Size and Properties” Option
![](https://spreadcheaters.com/wp-content/uploads/Step-4-Choose-the-Size-and-Properties-Option.png)
– Choose the “Size and Properties” option in the context menu.
– The “Format Picture” pane will open.
Step 5 – Check the Following Checkboxes
![](https://spreadcheaters.com/wp-content/uploads/Step-5-Check-the-Following-Checkboxes.png)
– 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
![](https://spreadcheaters.com/wp-content/uploads/Step-6-Now-Protect-the-Sheet.gif)
– 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
![](https://spreadcheaters.com/wp-content/uploads/Step-7-Now-Check-if-the-Picture-is-Locked.gif)
– Now check the picture is locked.
– The picture will not get selected and neither it can be resized.