P
Preinal
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I need to protect from editing ONLY SOME cells in a sheet, not the full sheet. How can I do? Thanks!!
B
Bob Greenblatt
Select the cells you want to protect and set the protection status in
format-Cell-Prrotect. Then protect the sheet with or without a password.
P
Preinal
Bob, many thanks for your answer, but it do not work either. I've been trying this the whole afternoon, but the procedure protect the whole sheet not some selected cells. I need to do a survey, and some cells need to be filled, and other protected.
C
CyberTaz
Not to be argumentative, but the procedure does in fact work 
You first need to select the cells you want to remain editable, then go to
Format> Cells> Protection, clear the Locked checkbox. Once you've removed
the Locked property for those cells go to Tools> Protection> Protect Sheet.
If it isn't working for you we need to have complete details including:
Exact update level of both Office & OS X,
Origin of the file involved,
Step-for-step what you are doing, plus
Any additional details you can offer.
Regards |:>)
Bob Jones
[MVP] Office:Mac
You first need to select the cells you want to remain editable, then go to
Format> Cells> Protection, clear the Locked checkbox. Once you've removed
the Locked property for those cells go to Tools> Protection> Protect Sheet.
If it isn't working for you we need to have complete details including:
Exact update level of both Office & OS X,
Origin of the file involved,
Step-for-step what you are doing, plus
Any additional details you can offer.
Regards |:>)
Bob Jones
[MVP] Office:Mac
M
Mike Middleton
Preinal -
By default, all cells are locked. Locking cells has no effect unless the
sheet is protected.
(1) Select all cells, i.e., click the diamond-shaped icon in the upper left
of the worksheet.
(2) Choose Format | Cells | Protection, and clear the Locked check box. OK.
(If the Cells item on the Format menu is dimmed, choose Tools | Protection |
Unprotect Sheet.)
(3) Select just the cells you want to lock. For example, you can select the
first such cell, and hold down the command key while selecting the others.
(4) Choose Format | Cells | Protection, and select the Locked check box. OK.
(5) Choose Tools | Protection | Protect Sheet, protect the sheet for
Contents, and optionally enter a password. OK.
- Mike
http://www.MikeMiddleton.com
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel
I need to protect from editing ONLY SOME cells in a sheet, not the full
sheet. How can I do? Thanks!!
By default, all cells are locked. Locking cells has no effect unless the
sheet is protected.
(1) Select all cells, i.e., click the diamond-shaped icon in the upper left
of the worksheet.
(2) Choose Format | Cells | Protection, and clear the Locked check box. OK.
(If the Cells item on the Format menu is dimmed, choose Tools | Protection |
Unprotect Sheet.)
(3) Select just the cells you want to lock. For example, you can select the
first such cell, and hold down the command key while selecting the others.
(4) Choose Format | Cells | Protection, and select the Locked check box. OK.
(5) Choose Tools | Protection | Protect Sheet, protect the sheet for
Contents, and optionally enter a password. OK.
- Mike
http://www.MikeMiddleton.com
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel
I need to protect from editing ONLY SOME cells in a sheet, not the full
sheet. How can I do? Thanks!!
P
Preinal
Thanks Guys, I got it. Cyber Taz helped me a lot. Merry Christmas!!