Locking Only Inset/Delete Column/Row Option

**Masa1989** · 05-10-2015, 03:54 AM

Hi Guys

Is there any way we can lock inserting/Deleting Row/Column option.?
I should be able to work and edit the cells as normal.
When i check the insert column or rows in protect sheet option, all the cells of a sheet get locked.

Thanks in advance for your help

**Nisha Dhawan** · 05-10-2015, 08:57 AM

Hi,

To lock only insert/delete to row/column follow below given steps and image:-

go to Review> Protect Sheet

Protect sheet.PNG

**newdoverman** · 05-10-2015, 09:38 AM

Select all cells that you want to be able to edit, right click, choose Format Cells, click on the Protection tab and uncheck the locked option, click ok. Protect the worksheet with

Protect Worksheet.jpg

All unprotected cells should be available to you.