Hai sir,
i want to make a cell which is non-deletable in excel
plz any body can help me?
If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.
Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.
140 views
Usually answered in minutes!
×