Excel How-to
Data Validation List from Another Sheet in Excel
Point an Excel or Google Sheets drop-down at a list on another sheet. Use a sheet-qualified range or a named range, and keep the header out of the source.
#drop-down
2 tutorials tagged “drop-down”.
Excel How-to
Excel Drop-Down List Not Working (Blank, Missing Items, or Won't Appear)
Fix an Excel or Google Sheets drop-down that will not open, shows a blank, or is missing items. Check the validation rule, the source range, and in-cell dropdown.