How to protect collumn formula

[LyviaChung]

Dear,

I setup a formula for collumn, and I don't want anyone to change it.

But I don't know how to setup it.

Lyvia

On 2002-03-10 19:51, LyviaChung wrote:
Dear,

I setup a formula for collumn, and I don't want anyone to change it.

But I don't know how to setup it.

Lyvia

do you just want to protect that column? if so select all columns except the one you don't want to be changed,(hold down the ctrl key to select multiple columns, or if you're selecting all columns to the right of the one you want to protect hold down ctrl+shift and press the right arrow key)and go to format menu>cells>protection tab and uncheck the 'locked' checkbox. then go to tools menu>protection and protect the sheet as instructed. then any cell except those in your protected column can be edited. is that what you wanted?