I have a spreadsheet of 30 columns to which I applied the OOB data form feature so that for new data entry, a user could just select the form button in the top ribbon and enter a complete row of data within the form modal box. However, the 7 or so columns where I have drop-down lists in the worksheet did not carry over as drop-down lists on the form modal. I don't see where there are any configuration settings to accomplish this with the data form functionality. Is it possible?

I've read about using form controls (list box or combo box) but it seems that they are only compatible with the worksheet itself, not with the data form generated.

Also, when I use the data form to enter a new row, it's popping the entered data down around row 1500 rather than in the first empty row of the worksheet. Any ideas how to correct this? Thank you!