Forum Discussion
Can I delete a cell entry, but lock a cell formula so it's retained?
Hi
Thanks for the attachment
You can lock cells from accidental deletion.
The technique is to actually unlock the cells you want to type in and then protect the worksheet
Highlight the Amount cells and right click and choose Format Cells, then go to the Protection tab and uncheck the Locked box
Then go to Review > Protect Sheet and you will only be able to edit the "unlocked" cells
Hi
Please find attached an example (I hope I've managed to attach it OK).
I'm not sure but I think we've been at cross purposes. You can see in the sheet that there are formulas in the 'VAT', 'Total Incl VAT' and 'Totals' columns/rows. If I delete an entry in the 'Amount Ex VAT' column, there's not a problem because the cells in that column contain no formulas. However, if I delete an entry in cells containing formulas, both the entry (e.g. £20 in the VAT column) and the formula are deleted; this is a problem because when busy, it's easy to accidentally delete the entry and formula when just the entry was meant to be deleted. Therefore, can I lock (for want of a better word) cells with formulas so that the entry can be deleted while leaving the cell formula untouched/in place?
Thanks
R
Hi
Thanks for the attachment
You can lock cells from accidental deletion.
The technique is to actually unlock the cells you want to type in and then protect the worksheet
Highlight the Amount cells and right click and choose Format Cells, then go to the Protection tab and uncheck the Locked box
Then go to Review > Protect Sheet and you will only be able to edit the "unlocked" cells
I followed these steps however the unlocked cells when edited and a user clicks delete the formula deletes. How can I protect the formula from a user deleting it on accident when they're trying to only delete their work? Wyn Hopkins
The photo below shows where the green highlight is at, the formula that was present is deleted and where the $ signs are the formula is still present.
