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
Alternatively you may create helper spill, e.g. at Sheet2!L3, as
=TOCOL(Sheet2!A2:A500,3)and create drop-down with the reference
=Sheet2!$L$3#It also will be dynamic.
Hi!
Thank you!
I'm going to try this and have my daughter test it.
Thank you again!! 🙂