How to allow user to only edit pictures in unlock cells when sheet is protected

Question

How to allow user to only edit pictures in unlock cells when sheet is protected

Ben 20

Hi Experts,

I tried to protect sheets for the locked cell with a picture. But if I uncheck the "edit objects" option at the protect sheet, user cannot insert picture. All options for picture is greyed out. But if I check "edit objects" option, user can move the picture in the locked cell as well.

0 comments

Answer accepted by question author

Anonymous

Dear @Ben,

Thank you for reaching out to Microsoft Q&A forum. I am happy to assist you.

Here is how to allow users to insert/edit a picture only in a specific area of a worksheet, while keeping the rest of the sheet protected.

Prepare the worksheet

Lock default cells

Select the cells that should remain protected. Go to Home > Format > Format Cells > Protection and ensure Locked is checked. User's image

Unlock the “picture drop zone”

Decide the area where users may insert/edit a picture (e.g., a merged range D2:J16).

User's image

Select that area > Format Cells > Protection > uncheck Locked.

Protect the sheet

Go to Review > Protect Sheet. To allow picture insertion/editing, check Edit objects.

User's image

(Keep other permissions as needed, e.g., allow selecting Unlocked cells only.)

Note: This method does not apply to pictures that float independently of the cells.

After the changes, users can insert/edit pictures in the unlocked area (e.g., D2:J16).

If they try to modify pictures over locked regions, Excel protection will block the action and show a dialog.

User's image

When a picture is floating outside of the cells (meaning it is not inserted inside the cell grid but placed freely on top of the sheet), Excel treats it as an object, not a cell‑based element. Because of this, when you enable “Edit objects” in the Protect Sheet settings, all users will be able to edit every picture or object on the sheet, regardless of whether the underlying cells are locked or unlocked.

This behavior is by design in Excel. Floating objects are not tied to specific cells, so Excel cannot limit editing to one particular area. “Edit objects” works as a global permission, once turned on, it applies to the entire worksheet.

If these steps do not match your intended end goal or do not achieve the result you want, please let me know in detail what you are trying to accomplish.

Additionally, if possible, please send me your demo file so I can take a closer look and provide a more accurate solution.

Kindly send it via private message to protect your PII.

Here's how you can access your private messages:

Go to a question you asked that has a private message.
Open private messages modal – by clicking link in blue banner or private messages button.
Private messages modal opens
Enter reply into rich-text editor.
Click "Send" button.

Providing these details will enable us to offer the most accurate next steps and, if necessary, route your request to the appropriate team for further assistance. Looking forward to your response so we can assist you further!

0 comments

2 additional answers

Your answer

Answer 1

Ben 20

Hi Viego,

I have to select "place over cell" as if I select "place in cell", it covers the wording.

Example of "place over cell" as attached
User's image

Example of "place in cell" as attached. If I select place in cell, it covers the wording "signature:"

User's image

Anonymous

2026-01-05T23:55:18.9833333+00:00

Hello @Ben,

Thank you for your response.

To clarify, the behavior you’re seeing is expected and aligns with Excel’s design. When an image or object is placed directly inside a cell, it will naturally overlap or cover any existing text or content in that same cell. Excel does not automatically reposition or wrap cell contents around objects.

To avoid this issue, I recommend inserting your signature or image into a different, empty cell so that it does not obstruct the text you need to display.

This is part of how Excel handles objects within worksheets, and adjusting the placement of the image is the most effective way to prevent content from being hidden.

I understand how valuable it would be to have a feature that allows you to lock or protect specific objects in Excel. And I fully agree that such a capability would be extremely beneficial for users who work with structured layouts or embedded objects.

As a forum moderator, I can help provide guidance, explain current product behavior, and suggest available workarounds. However, I do not have the ability to modify or change Excel’s product features. Feature design and development are handled directly by the Microsoft product teams.

So I encourage you to submit feedback directly to Microsoft via the Office 365 app (Help > Feedback), or through Feedback Hub by

Go to: Microsoft 365 Feedback Hub > Send Feedback > Describe your proposal in detail.

Sharing your experience through this channel is the most impactful way to advocate for a change that would benefit you and other users.

While I can't change the product's design, please don't hesitate to reach out if you have any other questions about its current functionality. Your perspective is important, and I’m confident it will support the continued development of the Office 365 Apps experience.

If you need any further assistance, feel free to reach out. I am here to help. Thank you very much for your understanding and your cooperation.
Anonymous

2026-01-07T01:44:18.6166667+00:00

Hello @Ben,

Thank you for confirming that the information was helpful in your private message. If you found my response useful, please mark it as the Accepted Answer and give it an upvote. Doing so will make the solution more visible and help other users facing the same issue find it quickly.

If you need any further assistance, feel free to reach out. We're here to help. Thank you very much for your understanding and your cooperation.

Wish you have a great day.
Ben 20 Reputation points

2026-01-07T01:52:50.8133333+00:00

Hello Viego,

Ok, as I am new to this, I did not click the "Accepted Answer". I just clicked it and also give an upvote. Thank you for notification and your effort in answering.
Anonymous

2026-01-07T02:18:11.8033333+00:00

Hello @Ben,
Thank you for your kind appreciation and the effort you’ve put in.

If you need any further assistance, feel free to reach out. We're here to help. Thank you very much for your understanding and your cooperation.

Wishing you a pleasant day!

Answer 2

To allow users to edit pictures in unlocked cells while keeping other cells protected, you can use the following approach:

Protect the Worksheet: When you protect the worksheet, ensure that you check the option to allow users to edit objects. This will enable users to interact with pictures and shapes on the worksheet.
Lock the Cells: Make sure that the cells where you want to restrict editing are locked. You can do this by selecting the cells, right-clicking, and choosing Format Cells, then navigating to the Protection tab and ensuring the "Locked" option is checked.
Unlock Specific Cells: For the cells where you want users to be able to insert or edit pictures, you need to unlock these specific cells. Select the cells, right-click, choose Format Cells, go to the Protection tab, and uncheck the "Locked" option.
Insert Pictures: With the worksheet protected and the specific cells unlocked, users will be able to insert pictures into those unlocked cells. However, they will not be able to edit or move pictures in the locked cells.

By following these steps, you can achieve the desired functionality where users can only edit pictures in unlocked cells while keeping the rest of the sheet protected.

References: