Create Drop-Down Lists in MS Excel 2007

Dennis Faas's picture

Sometimes you want someone to select only from a list that you offer in your worksheet. This is very easy to do in MS Excel 2007.

Follow the steps below to learn how:Select row or column cells you will not be using. 

  • Place one list item in each cell.
  • Where you would like the drop-down list to appear, highlight the cells -- they need not be contiguous.
  • Click on Data | Validation.
  • Under Allow, select List.
  • Check In-cell dropdown.
  • Left-Click the Source box and highlight the cells containing your list. 
  • Click OK.

Not difficult at all!

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet