How to create a drop down menu in Excel 2010
Posted By quikStarts April 20, 2011 08:37 pm List View Grid View

This guide is part of the Microsoft Excel 2010 series

Guides in this series:



Make: Microsoft

Model / Product: Excel

Version: 2010

Objective / Info: Learn how to create a drop down menu in Excel 2010. In this guide, we are using a spreadsheet with existing data but these steps should work in a blank spreadsheet as long as you add the data.


1
Open Excel by double left clicking the icon on the desktop or start menu or open the document that you want to work on.

2
Click on the cell where you want to place the drop down menu.
  Note : In this example, we are going to keep cell A1 and use the data in cells A2-A6 as drop down options so we select A2.

3
Select the "Data" tab from the menu bar.
4
Click the "Data Validation" button.

5
Select "List" from the "Allow" drop down field.
6
Left click on the "Source" field.
7
Click and drag across the cells that you wan to include in your drop down list.
  Note : The source fields are the cells that contain the options that you want to appear in your drop down list. These cells can be located anywhere in your worksheet or workbook.

8
Click the "Ok" button when you are finished making your selection.
9
At this point you can click the cell and you should see a drop down list containing the data you selected.
10
This task should be complete. Review the steps if you had any issues and try again.Submit questions or request for more guides in the questions section below.

|

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(5)


Name
Email
URL
Comment
 
 
 
 

Search Categories

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

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   uppidy   instagram   Google Drive