Tuesday, 9 February 2021

Excel - Make excel column uneditable

 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