Protection

[adavies]

How do I protect a range of cells to make it read only?

I've been using the protection option on the menu, but it always protects the whole sheet?

 

[sykes]

Hi Adisorn

Select your range, from the top toolbar go to format / cells / protection and select "locked." then protect the sheet.

You'll have to unlock all of the other cells on the sheet that you want to keep read/write though, of course you just use the same method, select them all at once but "Unlock" them.

 

[adavies]

tHANK yOU

Thanks,

I'm a little backwards tonight... that's what I was doing, but I was locking the wrong cells.... ops!