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
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