I have a column with unique values in excel and shared in sharepoint, others should not be able to edit that column. How to make that column as non editable?
Kindly any one help please.
I have a column with unique values in excel and shared in sharepoint, others should not be able to edit that column. How to make that column as non editable?
Kindly any one help please.
Hi,
Welcome to the forum.
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.
Thanks a lot for your reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks