In Google Sheets I use validations most of the time, based on a column in another sheet.
In Excel 2016 I want to achieve the same. It does give me a dropdown list to select a value from, for example: the validation source =DB_data!$AD2:$AD5000. It starts from row 2 because that is where the data starts. To make this list dynamic, meaning: if we add more records to this list, it is included automatically in the validation.
However, in Excel, it also shows blank cells in the dropdown validation field.
How can we remove the blank cells from the validation dropdown list?