Hi All,
I have a requirement where I have to create an excel sheet with few columns as uneditable. I have used the below steps to resolve it
To make a column non-editable:
1. Select the whole worksheet, Right Click->Format Cells->Protection, uncheck the "Locked" check box.
2. Select the column you want to protect, right Click->Format Cells->Protection, select the "Locked" check box.
3. Review tab->Protect Sheet, select the "Protect worksheet and contents of locked cells" check box and protect the sheet using a password.
Enjoy working :)
No comments:
Post a Comment