This Excel tutorial (about 4min) explains how you can create a dropdown list in Excel and leave a single choice of data to the user of the file.
Very useful for providing essential and mandatory information in tables, you will quickly become a fan of this function.
This screencast was made on the 2007 version but we obviously find the same functionality in the 2010 version. It is also the same operation in 2003…
