Hi All, I am a new member here. I am having issues creating a simple drop down list in Excel for Mac 2011 (14.1.4) and have turned to the forum for advice/help.

To summarize:
I want to create a drop down menu/list in a column on my spreadsheet (tab 1) that references a list on another tab of my spreadsheet (tab 2). The list on tab 2 is not contiguous, as it is groupings, which I will add to over time (they are recipes). I thought there was a way to skip the blanks in the drop down menu/list creation in tab 1 (found within Data > Validation).

If there is anyone who can help me it would be really appreciated. Let me know if you need more details.

Thanks,
MC