I am trying to lock or protect cells that have data validation, formatting and /or formulas in a cell. my dad selects the entire row and deletes the data but when he does it also deletes the formatting, data validation info, and the formulas. Is there a way to lock that info but still be able to add the data to a cell?
Solved by V. U. in 17 mins