Locking two rows together so they can't be split

[megwp]

Hello!

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?

Thanks

[#2]

@megwp 

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.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@NikolinoDE 

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.

[#4]

@megwp 

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

NikolinoDE

I know I don't know anything (Socrates)