MS.Excel- Is it possible to password protect one or two columns in an excel file?

Question

Hi

I have an excel file which would be available on a shared drive. I want the users to be able to access all columns except one or two columns. Except the two columns which are protected all other columns should be editable.

thanks

Answer 1

You can select a whole column, then go to Format/Cells and then the protection tab, and tick to protect them. Then go to Tools, protection and protect sheet to apply protection.

Answer 2

it is possible to protect the sheet, then allow certain ranges to be editable under tools->protection