Forum Discussion
NO delete individual cells... YES delete entire lines
Good morning. I'm using Excel 2013. I would like to know if there is a possibility to prevent the deletion of individual cells, but it is possible to delete the entire line. Thank you, Matteo
Hi,
If you mean to delete the row with protected cell - nope, that's not possible. If the row is in another range - yes. More about the options is here https://support.office.com/en-us/article/Lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a
Hello!
I have a table with operations to do. When these are completed, the row must be deleted (the entire row!).
It's important, however, not to delete only one or more cells, but always and only the entire line.For my knowledge that doesn't work. If you protect cell from deleting its content, you protect it from editing.
