protecting cells (Excel 2000)

D

David Kinston

How do I prevent certain cells from being altered, allowing
users to enter data only in certain areas.

I can only see how to protect an entire sheet or workbook.

Cheers

David Kinston
melbourne.au
 
F

Frank Kabel

Hi
first select the cells for which you want allow entries. Goto Format -
Cells - Protection and uncheck 'Locked'. Now protect the sheet
 
D

David Kinston

worked it out!

How do I prevent certain cells from being altered, allowing
users to enter data only in certain areas.

I can only see how to protect an entire sheet or workbook.

Cheers

David Kinston
melbourne.au
 
Top