Creating a drop-down list in Excel

June 22, 2006 by Isaac

What? An Excel tip in a software testing blog? It seems I spend way too much time creating reports for my managers, so I do rely heavily on Excel. While creating a generic risk assessment spreadsheet I wanted to only allow certain values in some of the cells. After a quick google and some playing with settings I found this article about how to do just such a thing in Excel. Pretty cool if you ask me.

Posted in Windows