Read only column

[rahul_oberoi]

Hi Experts,

I have a very simple requirement . Please help in finding solution. 

I want to share this file to 100 users, I want to restrict Column A, Column B and Column C to read only. So that no one can change the value apart from owner of the file. 

Please help in suggesting the steps.

Thanks 

Rahul 

[#2]

@rahul_oberoi 

This might help

https://support.microsoft.com/en-us/office/lock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410...

[#3]

Not really helped, but I would like to protect only the 3 columns, if you can provide the steps.

[#4]

@rahul_oberoi 

Use Format...Cells....Protection to deselect (unlock) the cells you want people to be able to change. i.e., remove the "locked" check.

Then on the "Review" toolbar, select "Protect Sheet," which has the effect of locking all of the remaining cells. To make it really securely locked, use a password (just make sure it's one you will remember).

Granted, it's not an obvious procedure. As is always the case, there are YouTube videos on the process.