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

​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  Read More

​