How to make data validation list drop-down appear in first column of new row?
Posted on 2014-02-25
Hello - I've got a data entry table of 10 columns and 100 rows. I've got col 1 (A) set up with a data validation list. It works fine on the existing 100 rows, but when I go down to row 101 and click in the cell at col A, the list drop-down arrow does not appear until I actually make an entry in that cell, and move out of it. THEN I see the drop-down arrow appear, and the table expands to include this new row.
How do you set up the table and/or data validation list to be available on the first blank row of a table?
(This table started out as a range; I selected it, and made a table out of it. Maybe that's my problem?)
This is in Excel 2010