Forum Discussion
Locking two rows together so they can't be split
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
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
