This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to create a simple form for staff to complete on the online version of Excel. Most of the cells are locked and the sheet is protected to avoid manipulation of data that needs to remain as it is. I want to find a quick and easy way to clear the contents of the unlocked cells. Selecting all cells and clicking delete does nothing. The only way I can find is to highlight a range of unlocked cells and clear them, highlight the next range of unlocked cells and clear them, and so on. There must be an easier way! I tried to upload a screenshot but was unsuccessful, so below is an example of the format. Any advice would be GREATLY appreciated!
| Locked | Locked | Locked | Locked | Locked | Locked | Locked |
|---|---|---|---|---|---|---|
| Locked | Unlocked | Unlocked | Unlocked | Unlocked | Unlocked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
| Locked | Unlocked | Unlocked | Unlocked | Unlocked | Unlocked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
| Locked | Locked | Locked | Locked | Locked | Locked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
| Locked | Unlocked | Unlocked | Unlocked | Unlocked | Unlocked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
| Locked | Unlocked | Unlocked | Unlocked | Unlocked | Unlocked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
| Locked | Locked | Locked | Locked | Locked | Locked | Locked |
| --- | --- | --- | --- | --- | --- | --- |
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Aiden,
I was looking for a convenient way to clear them all at once, but I can see that's not possible.
Thank you for taking the time to respond, though.
Cassy
Hi, cramoswalton
Thank you for using Microsoft products and posting them to the community.
The Online version has some limitations in directly clearing the contents of unlocked cells in batches, but you can directly select the unlocked area and then press the Delete key on the keyboard to clear it. This is also the most convenient solution at present. Are you unable to delete because you selected all?
I hope the above information can help you. Feel free to send a message if you need further help.
Best wishes
Aiden.C - MSFT |Microsoft Community Support Specialist