Read only column

Question

Hi Experts,I have a very simple requirement . Please help in finding solution.&nbsp;&nbsp;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.&nbsp;&nbsp;Please help in suggesting the steps.&nbsp;Thanks&nbsp;Rahul&nbsp;&nbsp;&nbsp;

mathetes · Answer

rahul_oberoi&nbsp;&nbsp;This might helphttps://support.microsoft.com/en-us/office/lock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410acaf21&nbsp;&nbsp;

rahul_oberoi · Answer

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

mathetes · Answer

rahul_oberoi&nbsp;&nbsp;Use Format...Cells....Protection to deselect (unlock)&nbsp;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.

Forum Discussion

Read only column

Share

Resources