Monday, 4 February 2013

How to create and use Excel's drop-down lists

Excel has a great feature to improve productivity by using drop-down list. If you have specific list of allowed entries to a cell, use drop-down list! In my example video below my list contains car brands. Creating list is easy:

  1. Type down your list items to Excel worksheet. It might be a good idea to put list to different worksheet than your main data.
  2. Activate cell where you want to use the list
  3. Select Data-tab from the Excel's Ribbon menu.
  4. Select Validate
  5. From the Allow drop-down list, select List
  6. Click the painting tool on the right hand sight of the Source box
  7. Select list items you typed in the first phase
  8. Press Enter
  9. Now you have drop-down list for selecting items in the cell you activated
Following video demonstrates this:

No comments:

Post a Comment