Dear Community, 

I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one. 

For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values.

Is there anyway to achieve this?

Your inputs are highly appreciated 🙂 

​Dear Community,  I have browsed several threads on the platform to find solution to this specific problem but havnt got it anywhere. I know that there is a methodology to lock the cells in a spreadsheet from editing as well as lock in formats to stop users from changing them however how do I do both in one. For example, I have a spreadsheet in which there is a table. I would like to lock the columns A,B and C such that users are not able to edit value, at the same time I would like to lock cells in column D,E,F such that users cannot paste in values but access the drop down lists in cells to select values. Is there anyway to achieve this? Your inputs are highly appreciated 🙂   Read More

​