Forum Discussion
Solved
Why do dropdown lists appear differently on different computers and can it be changed?
Hi! I've created a dropdown list and the table that it references has 500 rows but only the first 20 rows are filled. On my computer, running Excel 365 and Windows 10, when I click on the dro...
If data validation list is based on the structured table located in the same sheet of the workbook, it expanded automatically with expanding of the table.
If table is on another sheet of same workbook, that doesn't work. As workaround for the drop-down list you may use formula like
=OFFSET(Sheet2!$A$2,0,0, COUNTA(Sheet2!$A$2:$A$500) )instead of the direct reference
=Sheet2!$A$2:$A$500
If data validation list is based on the structured table located in the same sheet of the workbook, it expanded automatically with expanding of the table.
If table is on another sheet of same workbook, that doesn't work. As workaround for the drop-down list you may use formula like
=OFFSET(Sheet2!$A$2,0,0, COUNTA(Sheet2!$A$2:$A$500) )instead of the direct reference
=Sheet2!$A$2:$A$500
Thank you so much, Sergei! I used the OFFSET one and it worked, thank you so much! 🙂
Have a wonderful day!
Diane
Have a wonderful day!
Diane