Forum Discussion
Protect sheet by adding data in table
Hi Community,
I have a table with 5 columns, of which I need to protect 2 so that the data is not changed. The other three columns must be unlocked in order to be able to enter new data. The problem is that when I go to protect the sheet, although I can enter new data, it does not automatically enter into the table.
Does anyone know how to make some columns locked, but once new data is entered at the end, it is automatically included in the table?.
Thanks,
Francisco
2 Replies
Here's the guide to protect certain ranges >>> Protect Excel Sheet but Allow Data Entry (2 Handy Approaches)
- When you protect your sheet, select the "Insert rows" checkbox. Then you can insert a row at the end of your table everytime you'd want to add new data to your table. Make sure to leave an empty row at the end of your table so you could select the empty row while inserting a new row.
