Prev: Letter = Number
Next: Preventing Changing Formula's
From: Polochilde on 5 Jul 2008 17:29
How can I protect two columns in a sheet. Eg. I could enter data in any cell
except in the cells of colums K and M.
--
Many Thanks. Regards,
From: Lorne on 5 Jul 2008 17:40
"Polochilde" <Polochilde(a)discussions.microsoft.com> wrote in message
news:12446B0C-E112-4E03-84AE-63A9DCFCF8A6(a)microsoft.com...
> How can I protect two columns in a sheet. Eg. I could enter data in any
> cell
> except in the cells of colums K and M.
> --
> Many Thanks. Regards,

You need to lock the cells. How you do that depends on the version of Excel
you have - press F1 and read the help file for 'lock cells'


From: FC on 5 Jul 2008 17:49
Select the whole worksheet ( Ctrl A )
Format menu ( Ctrl 1)
Protection tab> uncheck "lock" OK
Select columns K and M
Ctrl 1
Protection tab
CHECK " lock " OK
Protect whole worksheet :
tools>protection>protect sheet and
choose a password, password again > OK


"Polochilde" wrote:

> How can I protect two columns in a sheet. Eg. I could enter data in any cell
> except in the cells of colums K and M.
> --
> Many Thanks. Regards,
From: Polochilde on 7 Jul 2008 01:13
Thank you. This was very helpful.
--
Many Thanks. Regards,


"FC" wrote:

> Select the whole worksheet ( Ctrl A )
> Format menu ( Ctrl 1)
> Protection tab> uncheck "lock" OK
> Select columns K and M
> Ctrl 1
> Protection tab
> CHECK " lock " OK
> Protect whole worksheet :
> tools>protection>protect sheet and
> choose a password, password again > OK
>
>
> "Polochilde" wrote:
>
> > How can I protect two columns in a sheet. Eg. I could enter data in any cell
> > except in the cells of colums K and M.
> > --
> > Many Thanks. Regards,
 | 
Pages: 1
Prev: Letter = Number
Next: Preventing Changing Formula's