Locking/Freezing contents of a column

**LisaO** · 04-15-2009, 07:33 AM

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

**oldchippy** · 04-15-2009, 08:14 AM

Hi,

Welcome to the forum, why not just hide columns B, C, D, E?

**LisaO** · 04-15-2009, 08:23 AM

Originally Posted by oldchippy

Hi,

Welcome to the forum, why not just hide columns B, C, D, E?

Many thanks oldchippy. I'm new to spreadsheets and didn't realise you could do that either.

Problem solved, thanks again

**oldchippy** · 04-15-2009, 08:28 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save