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.
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.