HOW DO I CREATE A DROPDOWN MENU IN A CELL

  • Thread starter Thread starter Guest
  • Start date Start date
Data -> Validation -> List

The list can either be a set of values that you enter separated by comas or
it can be a link to a range of cells. In order to link to a range of cells
that is on a different sheet that range must be a named range. Additionally
if you wnat the list to shrink and grow then you nned to link the list to a
dynamic named range. Here is a link to dynamic named ranges.

http://www.cpearson.com/excel/named.htm
 
Back
Top