Excel: Data Validation List Source in Other Worksheet

Ever tried to limit what users can enter into a cell by making a drop-down list using Excel's Data Validation feature? You might have had a hard time selecting a range from another worksheet to use as the list source. Thankfully, there is a way to make it work. If you name the range in the other worksheet that you'd like to use as your list source, and enter that name range as the source in the Data Validation dialog box, it'll work just fine!

(Use "=TheRangeName" as opposed to something like "=Sheet2!$A$1:$B$4").


Post a Comment