Locking the ability to insert rows or columns

Question

I need to lock a worksheet to prevent users from adding/deleting rows and columns.  I need them to be able to edit the rows, type in data and update, but need to prevent inserting rows/columns or deleting them.

Is this possible?

Answer 1

Hi,

You can protect the worksheet by click Home Tab - Format - Protect sheet. See the snip below

What you do is apply a check mark against all things you want then to be able to do so leave add/delete rows and columns un-checked. You can also add a password.

Answer 2

It doesn't work when I protect the sheet, this takes away the ability to type content into cells, which I need them to do, just need to restrict the ability to add or delete columns and rows.

Answer 3

Hi,

It does work. See the snip below click the symbol above the 1 to select all cells then right click any cell and click 'Format cells' and on the protection tab remove the checkmark from the 'Locked' box.

Now follow the instructions in my previous post and check everything in the popup except insert rows/columns and delete rows/columns