Excel 2013: New row added automatically but first 2 columns Drop down lists not available...

Jun 29, 2017
Reaction score
Excel 2013:
We have a worksheet table style where the first two columns each have a drop down list for users to select respective entries.
After filling in a rows' data and pressing Enter/Return a new row is added to the table but the drop down list is not included until the user enters data in another free form column.
Is there any way to have the drop down working in the first two columns without having to enter free from data in another column of the new row?
We don't use VBA in our workbooks.
Thanks fo rany advice / help.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question