ms excel training - Protect cell

Hi Tanuja

Thanks for your question.

You can protect a worksheet by going to Tools - Protection - Protect Sheet. You can then set a password to control the protection if you wish.

Once you have set protection, you can remove it by going to Tools - Protection - Unprotect Sheet (then enter your password if you have set one).

You must remember to apply protection again (Tools - Protection - Protect Sheet) before saving and closing your file.

Amanda