Excel should lock individual cells or range only

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

Guest

In excel you have to protect the entire worksheet and then select a range
that can be edited. You should also have a function if you want to protect
individual cells only or a range of cells and the rest of the worksheet can
be edited

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
Your first statement is untrue, thus leading you to believe your second
statement to be true.

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP


In excel you have to protect the entire worksheet and then select a range
that can be edited. You should also have a function if you want to protect
individual cells only or a range of cells and the rest of the worksheet can
be edited

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top