Excel-lock.PNG

<div>
For the latest 2013 version:<br />
<br />
Lock cells in a worksheet<br />
<a href="http://office.microsoft.com/en-au/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx" rel="ugc">http://office.microsoft.com/en-au/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx</a>
</div>


For the latest 2013 version:

Lock cells in a worksheet
http://office.microsoft.com/en-au/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx [http://office.microsoft.com/en-au/excel-help/lock-cells-in-a-worksheet-HA010342979.aspx]

<div>
And you may know this, but to follow up on what chaau posted, you then select the cells you want to lock, right click on them and choose 'Format Cells', select the 'Protection' tab and check 'Locked'.
</div>


And you may know this, but to follow up on what chaau posted, you then select the cells you want to lock, right click on them and choose 'Format Cells', select the 'Protection' tab and check 'Locked'.

<div>
Thanks,<br />
<br />
It was staring me in the face the whole time :-)<br />
<br />
Regards,<br />
<br />
swjtx99
</div>


Thanks,

It was staring me in the face the whole time :-)

Regards,

swjtx99

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a sheet with cells I need to Lock. Once I do that and then protect the sheet, users can input data into unlocked cells but they can't change formatting (colors) on any cell in the sheet. I only wanted to lock certain cells, not disallow formatting in every cell. <br />
<br />
Any input would be appreciated.<br />
<br />
Thanks in advance,<br />
<br />
swjtx99
</div>
</div>


Hi,

I have a sheet with cells I need to Lock. Once I do that and then protect the sheet, users can input data into unlocked cells but they can't change formatting (colors) on any cell in the sheet. I only wanted to lock certain cells, not disallow formatting in every cell. 

Any input would be appreciated.

Thanks in advance,

swjtx99

Lock Cells/Protect Sheet

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