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

  • Thread starter Thread starter Fred Exley
  • Start date Start date
F

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.
 
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
 
Fred Exley said:
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.
Click to expand...

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
 
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
 
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
: >
: >
: >
:
:
 
Back
Top