How do you lock cells - the format - but still allow data entery?

D

daiblackburn

Try selecting the cell
and then from the Data menu select validation
this gives you a list of entries that can be made into that cell
 
Top