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

[Marc]

Especailly dragging and C&P to fill the cells?

Marc

[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

"Marc" <mcneer(N_O-S_P_A_M)@mindspring.com> wrote in message
news:[email protected]...
> Especailly dragging and C&P to fill the cells?
>
> Marc
>
>