qeng
asked on
Excel 2011 Drop-Down Lists don't copy correctly in newly inserted row
Using: Excel 2011 ver. 14.4.7
I'm using a Data Table in Excel 2011. When I try to create a new record by starting to insert data into a cell in the row immediately below the last row of my table (which is supposed to automatically get appended as a new record to my Data Table), some drop-down lists get copied correctly and others don't.
For example, in the attached image, if I entered the year 2014 as a means of starting the new record and hit 'return', the drop-down lists in the columns for Year and Month, get copied correctly from the Data Table, but no drop-down list gets copied for the Day column. I get a blank cell in the newly created cell under the Day column instead of the drop-down list which exists in all of the rows above it for that column.
Why is that occurring and how to correct it?
Please see attached image for example.
I'm using a Data Table in Excel 2011. When I try to create a new record by starting to insert data into a cell in the row immediately below the last row of my table (which is supposed to automatically get appended as a new record to my Data Table), some drop-down lists get copied correctly and others don't.
For example, in the attached image, if I entered the year 2014 as a means of starting the new record and hit 'return', the drop-down lists in the columns for Year and Month, get copied correctly from the Data Table, but no drop-down list gets copied for the Day column. I get a blank cell in the newly created cell under the Day column instead of the drop-down list which exists in all of the rows above it for that column.
Why is that occurring and how to correct it?
Please see attached image for example.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Spot on. Excellent troubleshooting from Simon.
ASKER
I had even tried to 'Circle Invalid Data' as well as making sure that the same formula (the valid drop-down list) in the first row had been copied (in fact, re-copied) to all rows in that column in the Data Table before trying to insert a new row at the bottom but that hadn't fixed it.
Your suggestion did!!!
Thanks a bunch.
(I have a few different Excel 2011 questions already posted in the pipe if you're feeling restless! :) )