Locking two rows together so they can't be split

New Contributor


I need to lock two rows together so that they can't be split and rows added between them. Is there a way of linking them together?


3 Replies


As a quick solution and as far as I understand your concern,

try locking the cells / columns of your choice so that they cannot be changed or moved.

Lock or unlock specific areas or cells of a protected worksheet



Hope I was able to help you with this info.



I know I don't know anything (Socrates)


Thanks for the reply. I have already tried locking them and changing the permissions but you can still add a line between the two locked rows. I need to be able to add rows above and below them so can't remove the ability to add rows.


After selecting the rows you want locked.

Select rows--> Format rows... --> Protection --> Tick on Locked.


Go to... Check--> Protect sheet --> All users of this worksheet may: tick "insert rows".

If you don't want to allow lines between them...unchecked (with out Tick).


I hope I understood correctly and that I could help you.

Thank you for your understanding and patience



I know I don't know anything (Socrates)