Forum Discussion

ediez2215's avatar
ediez2215
Copper Contributor
Oct 28, 2021
Solved

Drop-down for whole column in perpetuity

Hello! I've built a spreadsheet in Teams for a group of people to perform data entry at the same time. I have several columns that are drop-downs using data validation.

 

I would like it to be so they cannot delete the data validation, but still select options within the drop-down without having to unlock it. Also it would be great if no matter how many rows they add, those columns always have the drop-down. Are these things possible?

excel
  • mathetes's avatar
    mathetes
    Oct 29, 2021
    So long as you designate the range of data as an Excel Table, those characteristics will carry down, I believe. That's been my experience, at any rate. Works for both formulas and data validation.

2 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Oct 29, 2021
    So long as you designate the range of data as an Excel Table, those characteristics will carry down, I believe. That's been my experience, at any rate. Works for both formulas and data validation.