Do you never ever want the numbers to be altered? You could copy the column
and then 'paste special'...'values' right on top of the existing column. You
will then have the actual numbers rather than the forumlas in the column.
(Of course if you wanted to retain the formulas you could insert a new column
and do the same thing.)

"SiH23" wrote:

Hi,

I have a column with a series of Sum functions. I don't wish the totals to
be altered, is there anyway that I can lock the column to prevent this.

Many thanks,

Simon.