Make a column read olny

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Is there a way to make a column in Excel read only, so
that users will not be able to change the values in this
particular column?
 
Roy

lock the cells in the column (the default), unlock cells where you want
input and then protect the sheet with a password.

Format | Cells... | Protection tab | Locked = true (ticked)

Regards

Trevor
 
Thanks so much. Worked great
-----Original Message-----
Roy

lock the cells in the column (the default), unlock cells where you want
input and then protect the sheet with a password.

Format | Cells... | Protection tab | Locked = true (ticked)

Regards

Trevor





.
Click to expand...
 
Back
Top