By default, all cells are locked, and thus protected when you
protect the worksheet. To protect only specific cells, first
select all cells, go to the Format menu, choose Cells, then the
Protection tab, and clear the Locked check box. Then, select the
cells you want to protect, go back to the Protection tab and
check the Locked check box. Finally, protect the worksheet.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.