Make list of drop down items on worksheet Give list a Name Add data validation to cell, and allow List, using your named list