I'm trying to protect with password a column of IDs in excel, is it possible to do that without block the rest of the sheet?
Thank you.
I'm trying to protect with password a column of IDs in excel, is it possible to do that without block the rest of the sheet?
Thank you.
Excel cells have a property called " Blocked " by default.
This property is found by clicking Right Click on the cell or cells that you want, in the option " Format Cells " and the " Protect " tab . We can also use the shortcut CTRL + 1 .
This property is the one that we must disable. Since you are only looking to leave a column protected, you will have to disable the " Blocked " property of the whole sheet except the column you want.
You can do this by removing all the property to the whole sheet by selecting it all (or a considerable area you want) and returning the property " Blocked " to the column you want.
With this done, it only remains to protect the sheet as you would in any normal case and your column will be the only protected in the whole sheet.
Cells are blocked by default, you must disable the blocking of the cells you want to continue modifying Right click-cell-protection-blocked format When you disable it, even if you block the sheet, you can modify it.