Lock one or two columns only?

[jennie1153]

I have a spread sheet that I need to lock only one or two columns in not the entire document however I’m having issues doing it.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have selected the entire document and under formatting>Protection I have "Unlocked" all Cells. I then selected the cells I did not want to be edited and under format I selected "Locked".
<o></o>
<o></o>
After that I went to "Review" and "Protect Sheet" and attempted to choose only "Select Locked Cells" to add my password to but it keeps checking "Select unlocked cells" also! Then in turn locks the entire document... (Not what I wanted) Is there a way to make it stop automatically selecting both even if I only check one?
<o>

</o><o></o>
All in all I need column O and P locked because they are my charts for VLOOKUP through out the document, but the rest of the document open to be edited. <o></o>

 

[milesUK]

jennie1153, that's how it works on my copy of Exel2007 too.

You are doing it OK - first deciding what to protect (or Lock).

You then protect the worksheet. Once done the Locked cells are non-editable but may be selected & copied. The unlocked cells are left editable even though the sheet is locked.

Try it and see if the effect is what you want.