I have got a protected sheet in which some of the columns and rows are locked. Hence the user will not be able to edit these cells. But they can edit the unlocked cells.

But when i am trying to create a new column next to locked column or new row next to the locked row, the newly created column or row is also getting locked which is not the desired output for me.

If i create a new column, then it should be editable and the fresh format should be used. i mean it should not take the format of the adjacent cell while creating new column or row.

Can any of you help me on this issue.