Prevent deleting of cells

  • Thread starter Thread starter IHeartSpreadsheets
  • Start date Start date
I

IHeartSpreadsheets

Hello,

I have a spreadsheet that is used by many people to enter information. I
want to stop them from deleting individual cells or sections of cells but do
not want to protect the cells as I still need them to be able to enter
information.

Any ideas?

Thank you.
 
If you protect the sheet, and check every box other than delete column,
delete row, then you can select the range, or all ranges (unprotect book
first) and go to Tools->Protection->Allow Users to Edit Ranges->New, make
sure the ranges are in the box, and click Protect Sheet. Now they can edit
cells but they cannot delete rows or columns.
 
Back
Top