768 votes124 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
The idea of using Data Validation to prevent cell overwriting is flawed. If users paste data into the cell the Data Validation is overwritten.
On a positive note. I have found that if applied to All the cells in a specific Table column the Data Validation, Cell formatting and conditional formatting IS copied down when a new table row is generated. However, as soon as one cell is 'pasted into' then this "cell properties copy down" feature no longer works.