Sign in to submit new ideas and vote
Get Started

Prevent Row Deletion

Brad Jones
Brad Jones ✭✭✭✭✭✭

Can't find this in the Enhancement Requests, but it's all over the Community:

Quite simply, have a way to prevent users from deleting rows WHILE still allowing them to edit the unlocked cells in the row.

At minimum, create a popup warning the user they are about to delete a row. (there is a popup warning for "unlock row", but not for "delete row")

TAGS: Prevent deletion, deleted rows, restrict delete, block delete

6 votes

Idea Submitted · Last Updated


  • AMCGil
    AMCGil ✭✭✭

    Create an option to prevent non-admin users from deleting rows

  • spauliszyn
    spauliszyn ✭✭✭


    My sheet has ID numbers that depend on how many of a previous rows (by created date) of certain types/categories. If one use starts a row keeps it in draft stage, and then deletes it when they find they don't need it, it will affect all the subsequent ID's of rows that were created afterwards. I do not want them to delete rows unless there is a formula or other method that checks to see that it is the last one on the list (in created order) so that it cannot screw up subsequent ID's