Jan 13 2022 02:24 AM
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
Jan 13 2022 03:06 AM
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)
Jan 14 2022 05:06 AM
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.
Jan 14 2022 05:35 AM
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