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
Can you share your workbook so I can look ?
As example the attached (blank) workbook has 2 columns protected (no PW) highlighted in yellow. You can not enter data into the columns (as expected) nor can you insert rows (also as expected).
If you attach your file we can look to see what is happening.
Peter
Attached is a empty copy of the workbook I want to use.
I have put comments in the columns/rows that must be locked for editing, these contain formulas.
