I have a table being used to enter class-specific data for students. The
first column /field is a drop-down list of the different classes linked to a
dynamic range elsewhere.

Normally, typing anything in the new row "adds" a data record and drop-downs
appear as desired, but not in this case with the drop-down in the first
column.

I know how to work around this manually (enter something in one of the
typed-entry fields), but this is for use by a client and needs to be as
automated as possible. Besides, all the other entries are based on that
first selection from the drop-down list.

Thanks in advance.