<div>
You have to protect the worksheet to protect any cells. That means unprotecting the cells you want to be unprotecting versus protecting the cells you want protected.<br />
<br />
Select the whole sheet and unprotect the cells. Then select the cells you want protected and protect them. Then set worksheet protection on.<br />
<br />
Kevin
</div>


You have to protect the worksheet to protect any cells. That means unprotecting the cells you want to be unprotecting versus protecting the cells you want protected.

Select the whole sheet and unprotect the cells. Then select the cells you want protected and protect them. Then set worksheet protection on.

Kevin

<div>
Thanks for the quick response!
</div>


<div>
<div class="content wysiwyg-content">
Is there an easy way to lock specific cells within an excel workbook? I’ve got one w 8 sheets or so and just want to highlight the cells I want to lock and lock them. Ive searched online some and followed the steps but it doesn’t seem to work. I can lock the whole sheet easily, but not just certain rows and stuff. If there’s an easy step by step, please let me know.<br />
<br />
Thanks!
</div>
</div>


Is there an easy way to lock specific cells within an excel workbook? I’ve got one w 8 sheets or so and just want to highlight the cells I want to lock and lock them. Ive searched online some and followed the steps but it doesn’t seem to work. I can lock the whole sheet easily, but not just certain rows and stuff. If there’s an easy step by step, please let me know.

Thanks!

Locking Individual Cells in Excel 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.