How to add a drop down list in excel 2007
Posted By quikStarts July 24, 2010 11:21 am List View Grid View

This guide is part of the Microsoft Excel 2007 series

Guides in this 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.

|

Product Feedback
What do you dislike about this product?
What feature do you want to see added to this product?

Tag : spreadsheet

Create your own Guide

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment
 
 
 
 

Search Categories

  • Mobile Phone
  • Software
  • Internet
  • Programming
  • General
  • Travel
  • Home and Garden
  • ISP
  • Hardware

Search Tags

windows 7   Facebook login   windows xp   ftp   Google calendar sync   homepage   clear cache   ie 7   pdf   shapes   animate   image search   map   resolution   windows xp   Internet   computer   screenshot   word   chrome   encryption   temp files   toolbar   temp files   FireFox   php & mysql   google define   portable air conditoner   Smartrip Card   image   analytics   real time search   google docs   Gmail   archive   Paypal   pie chart   GOOG 411   publisher   boot cd   decrypt   email   screen recorder   skype setup   spreadsheet   picassaweb   clear history   outlook setup   hard drive   search history   zip   auto-save   ip address   comcast   dvr   caller id   Live movie maker   Mobify   IE 8   google voice   app inventor   rss   converter   netmeeting   wordpress   google tv   google toolbar   ipad   Google ebook   bookmarks   IE 9   android   Safari 5   Facebook   Facebook login   KeepVid   PowerPoint   block calls   data recovery   angry birds   mac address   G2   photoshop   YouTube   clear history   xoom   Google Plus   FireFox 5   Google Translate   evernote   buffer   android development   HootSuite