Forum Discussion

Copper Contributor

Mar 06, 2023

Read only column

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

Formulas and Functions

Silver Contributor

Mar 06, 2023

rahul_oberoi

This might help

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

rahul_oberoi
Copper Contributor
Mar 06, 2023
Not really helped, but I would like to protect only the 3 columns, if you can provide the steps.
- mathetes
  Silver Contributor
  Mar 06, 2023
  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.