Is there a way to protect just one cell, not the whole sheet?

[Fred Exley]

The books I read seem to indicate so, but say you first must turn on the
'Protect Sheet' option. When I do that, everything is protected. Any
help much appreciated.

 

[Frank Kabel]

Hi
try the following:
- first select all cells you don't want to protect
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect your sheet

 

[Gordon]

The books I read seem to indicate so, but say you first must turn on the
'Protect Sheet' option. When I do that, everything is protected. Any
help much appreciated.

First make sure the sheet is UN-protected. then select the cell, Right-Click
on it (assuming Excel 2002) and select the "Protection" tab. Unlock the
cell. then protect the sheet. You will find that all cells except the one
you selected are now protected.

HTH

 

[Fred Exley]

Thanks Frank and Gordon. I'm using Excel 97 right now, so maybe that's the
problem. But, I won Excel 2003 Upgrade on Ebay yesterday for $58.00, so
I'll try it again soon as I get it. Thanks again! -Fred

 

[Lady Layla]

Make sure you have an OS that will support 2003


: Thanks Frank and Gordon. I'm using Excel 97 right now, so maybe that's the
: problem. But, I won Excel 2003 Upgrade on Ebay yesterday for $58.00, so
: I'll try it again soon as I get it. Thanks again! -Fred
:
:
:
:
: : > : > > The books I read seem to indicate so, but say you first must turn on the
: > > 'Protect Sheet' option. When I do that, everything is protected.
: Any
: > > help much appreciated.
: > >
: > >
: >
: > First make sure the sheet is UN-protected. then select the cell,
: Right-Click
: > on it (assuming Excel 2002) and select the "Protection" tab. Unlock the
: > cell. then protect the sheet. You will find that all cells except the one
: > you selected are now protected.
: >
: > HTH
: >
: >
: >
:
: