I have some columns of cell where there are some formulas. What I
would like to do is to keep them fixed in their cell location so that
they wont get erased when the user selects all the cells. Is there a
way to lock them? I tried hiding the columns but even those column
cells gets selected and deleted by the user. Is there a way to do
this. Thanks in advance

Swamy

By default, all cells are protected when sheet protection is enabled.

Hit CTRL + a(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked"

Select the cells you want protected and FormatCellsProtection

Check "locked".

ToolsProtectionProtect Sheet. Note the options when protecting.

Supply a password and OK.

Excel's internal security is weak but this will prevent overwriting by accident.


Gord Dibben MS Excel MVP

On 14 Mar 2007 19:54:11 -0700, wrote:

I have some columns of cell where there are some formulas. What I
would like to do is to keep them fixed in their cell location so that
they wont get erased when the user selects all the cells. Is there a
way to lock them? I tried hiding the columns but even those column
cells gets selected and deleted by the user. Is there a way to do
this. Thanks in advance

Swamy

The user has to input data under some months and when once all those
months are over, the user has to delete the data and change the
months. This is why I want to protect the formulated cells. If I
enable protection, will I be able to do all these?

I have tried your solution and it seems to work fine. Thanks for your
help

try with
www.experts-exchange.com

Swamy

Select the cells you happy for users to work and from
Format/Cells/Protection remove the tick from Locked. Then choose
Tools/Protection/Protect sheet.

If users try to insert or delete anything in the formula cells they will not
be allowed to.

Try to unlock the cells which you will often use.

Then protect the work-sheet.

Then it will not allow anyone to select that cell which is locked.

I hope you know to unlock cells.