Protecting a field

[MariaL]

is it possible to protect a field in Excel? Not the whole
workbook.

 

[Paul B]

Maria, By default all cells in excel are protected or locked, select the
cells you want to unlock and go to format, cells, protection and uncheck
locked, the go to tools, protection, and protect sheet, enter a password if
you want, now only the cells that you unlocked can be edited.

Or if you only need a few locked I would select them all first, Ctrl A, then
go to format, cells, protection and uncheck locked, then select the cells
you want to lock and go to format cells and check locked, the go to tools,
protection, and protect sheet, enter a password if you want, now the cells
that you locked can not be edited
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[mzehr]

Sure. Simply select the range you want to protect,
format\cells\protection and check the Locked box. You
will need to make sure that the other cells that you want
users to be able to change are unlocked. You will need to
also protect the sheet for the cell protection to work.
HTH

 

[jeff]

Sure, select all the fields you DONT want
protected, goto Format/Cells.../Protection tab.
uncheck Locked. then goto Tools/Protection/
protect sheet.. use a password if you must.

jeff