Thursday, November 15, 2012

Create a Drop Down List in Excel


Today I’ll show you how to create a drop down list in 20 seconds:

1. Open the Data Validation window from the Data ribbon (or use the shortcut Alt => D => L)
2. Select the array you want to have in the drop down list





















Done!










For more posts about drop down menus, have a look at my other blog:

No comments:

Post a Comment