How can I password protect specific cell ranges in Excel?

Assume you wish to password protect cells A1 to B10.


Select the entire worksheet.

Then select from the menus Format > Cells > Protection > Locked (uncheck the box). Now none of the cells on the worksheet will be 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 be protected if you protect the worksheet.

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