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