Thursday, October 22, 2009

On Microsoft Excel how to protect specific cells only...???

I make Microsoft excel sheets for others to use at the office, but some times people erase the formulas by mistake, how can i protect just some epecific cells from been modify, not the whole work sheet, cuz there is some info that need to be put in from others to work on regular basis.



On Microsoft Excel how to protect specific cells only...???bmw



Select the cells that you want people to be able to change. Go to Format, Cells. Select the security tab. Uncheck the locked box. Protect the workbook.



Now the unlocked cells can be changed and all other cells will be protected.

No comments:

Post a Comment