Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to create drop down menus in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I need to add drop-down menus to my spreadsheet so the user can only select values from within a predefined list.



  1. Open Microsoft Excel 2007
  2. Click the "Data" tab
  3. On the "Data Tools" section, click the "Data Validation" button
  4. On the "Data Validation" window on the "Settings" tab, choose "List" from the "Allow:" drop-down menu
  5. In the "Source" field, type a list of values separated by commas
  6. Click the "OK" button

Alternate method:

  1. Open Microsoft Excel 2007
  2. Click the "Data" tab
  3. On the "Data Tools" section, click the "Data Validation" button
  4. On the "Data Validation" window on the "Settings" tab, choose "List" from the "Allow:" drop-down menu
  5. To the immediate right of the "Source" field, click the cell selection button (it looks like a miniature spreadsheet with a red arrow pointing to the top-left corner)
  6. Select the cells to be used as values for the drop-down menu
  7. Click the red X in the upper-right corner of the "Data Validation" window
  8. Click "OK"

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved