protect a single cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know how to protect a single cell, but the user can still add another row or column without unprotecting the sheet.
 
Hi Mahesh!

You can only allow insertion of rows and columns in Excel 2002 and
2003.

The approach is to change the defaults in the Tools > Protection >
Protect Sheet dialog. Place checks against "Insert Columns" and
"Insert Rows"

To protect a single cell:

Select all cells on the sheet by clicking the button at the
intersection of Row numbers and Column letters
Format > Cells > Protection Tab
Remove check from "Locked"
OK

Select the cell you want to protect
Format > Cells > Protection Tab
Place check in "Locked"
OK

Tools > Protection > Protect Sheet
In Excel 2002 and 2003 you can now vary user "rights"
Give and confirm the password [if required]
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
mahesh said:
I would like to know how to protect a single cell, but the user can
Click to expand...
still add another row or column without unprotecting the sheet.
 
Back
Top