How can I password protect specific cell ranges in Excel?

[rsenn]

Assume you wish to password protect cells A1 to B10.


Select the entire worksheet.

Then select from the menus Format > Cells > Protection > Locke
(uncheck the box). Now none of the cells on the worksheet will b
protected if you protect the worksheet.

Next select cells A1 to B10. The select Format > Cells > Protection
Locked (this time check the box). Now cells A1 to B10 will b
protected if you protect the worksheet.

Next select Tools > Protection > Protect Sheet. On the menu tha
appears, select the options you want, and give it your chosen password