protecting cells (Excel 2000)

  • Thread starter Thread starter David Kinston
  • Start date Start date
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
 
Hi
first select the cells for which you want allow entries. Goto Format -
Cells - Protection and uncheck 'Locked'. Now protect the sheet
 
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
 
Back
Top