I have excel 2007 and need to lock only certain columns. Does anyone know how
to easily do this? Thanks!
--

By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

FormatCellsProtection is where you would change the "locked" or "unlocked"
status.

CTRL + a to select all cells and unlock them.

CTRL + click to select the cells to be locked and lock them

Then ToolsProtectProtect Sheet.......add a password if you wish but these
are easily broken and will not stop a savvy user.

Note the selectable options under "allow users to" when protecting,


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 15:05:01 -0700, asynmyx
wrote:

I have excel 2007 and need to lock only certain columns. Does anyone know how
to easily do this? Thanks!

By default, CELLS are locked so if you protect the sheet they will be
locked. If you want unlocked select the columns to unlockright
clickformatprotectionunlockset protection.save.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"asynmyx" wrote in message
...
I have excel 2007 and need to lock only certain columns. Does anyone know
how
to easily do this? Thanks!
--