ExcelBanter - How do you lock cells - the format

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do you lock cells - the format - but still allow data entery? (https://www.excelbanter.com/new-users-excel/21062-how-do-you-lock-cells-format-but-still-allow-data-entery.html)

Marc

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

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" wrote in message
ink.net...
Especailly dragging and C&P to fill the cells?

Marc

All times are GMT +1. The time now is 04:40 PM.