Pre-Loaded Cells using Drop Down Menus

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I've come across a spread sheet that is using drop down
menus in many of the cells. These cells have pre-defined
items to choose from.
How did they do this? I can't seem to find the function
to recreate this.
Any ideas?
 
Thanks for your help MDW. You were correct.
I've never played with that section before. Cool!
-----Original Message-----
It probably wasn't a function. They probably went to
Click to expand...
Data > Validation (in Excel 2k, at least). In
the "allow" dropdown, choose List.
 
Back
Top