Locking/Freezing contents of a column

Hi there. Looking for some help please. I'm using Excel 2003 and was wondering if there was a way I could Lock/Freeze the contents of a column.

For Example:

Cell A1 has the formula =B1+C1+E1 - figure shown is £405
Cell A2 has the formula =C2+D2+E2 - figure shown is £650

Is there anyway I can freeze column A so when I delete column B,C,D,E ect the correct figure will still show?

Many Thanks in Advance
Lisa