How to add a drop down list in excel 2007





Posted By quikStarts
List View Grid View

This guide is part of the Microsoft Excel 2007 series



Make: spreadsheet

Model / Product: Excel

Version: 2007

Objective / Info: Learn to add a drop down list of options in a Microsoft Excel 2007 spreadsheet.


1
Open Microsoft Excel by double clicking the icon on the desktop or start menu.

2
You should see a new blank sheet.
3
Give a name to the column that will contain the drop down menu. For this example, I will use weather.

4
Click the tab named "Sheet 2" at the bottom of the workbook.
  Note : You can do this without using sheet 2, however, we are going to place this on another sheet so that it does not clutter the current page and looks cleaner.

5
I will now create the contents of the drop down list. Populate the cells in column A to include as many options as you want to include in your drop down list.

6
Select all of the cells that you populated for the drop down list, then type a name for that list next to the formula field and press enter.

  Note : For the example, I will name the list "conditions".

7
Now click back to Sheet 1 by selecting the tab at the bottom of the page, the same way you went to Sheet 2 in step 5.

8
Click the cell beneath the title, then click the "Data Validation" button from the menu.
9
Click the drop down menu beneath "Allow".
10
Select "List" and click "Ok"
11
Type the name you gave you list in step 6 into the "Source" field and click the "Ok" button.
12
You should now see a drop down arrow to the right of the cell.

13
Click the drop down arrow and you should see the list of items you created.

  Note : This task should be complete. Review the steps if you had any issues and try again.






comments powered by Disqus

Tag : spreadsheet

Create your own Guide

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment