Create Drop-Down Lists in MS Excel 2007
- by Carol Bratt on 20081203 @ 06:10PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: list, cells)
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 CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
