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 t...
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.
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.
ediez2215's avatar
ediez2215
Copper Contributor
Nov 05, 2021
That's awesome, thank you so much!