Forum Discussion
Solved
Adding rows in worksheet with locked columns
Hi all, I have a worksheet in which two columns are locked for editing with "protect worksheet". The problem is that I can't add any rows to the sheet now, even though the option to add rows is s...
Hi
when you protected the sheet you had not checked the very first option - Select Locked Cells.
That was all!
I would be grateful if you would mark this solution as complete!
many thanks,
Peter
Hi,
This is exactly what I want, thanks!
Can you explain to me what you have done to accomplish this so I can do it myself?
Many thanks!
This is exactly what I want, thanks!
Can you explain to me what you have done to accomplish this so I can do it myself?
Many thanks!
Hi
when you protected the sheet you had not checked the very first option - Select Locked Cells.
That was all!
I would be grateful if you would mark this solution as complete!
many thanks,
Peter
Hi Peter
I tried replicating this but in my own sheet this doesn't work. I still can't add rows if the cells are locked. Does this have anything to do with the fact that it's my first columns that are locked or not?
PS I uploaded my file
- Oh wow! Never guessed that would be the solution.
Again, many thanks for your help!