How to Create Pull-Downs in Excel
Creating a pull-down or drop down list, allows you to limit and standardize a set of user's choices. In the most recent version of Microsoft Office products, Office 2007, it is easy to create a drop down list using the tabs at the top of the page. The list can be as long or as short as you choose.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Excel to a new spreadsheet. Choose a row of blank cells, away from your spreadsheet's main formulas to create the list of choices. Or you can choose a separate spreadsheet within your workbook.
-
2
Write one entry into each cell. Add the next entry from your list in the cell below until you have typed in all of the available choices.
-
-
3
On the main spreadsheet, choose the cell into which you want to place the drop down menu. Click on it once so that it is highlighted.
-
4
If you are using Microsoft Excel 2007, click on the "Data" tab at the top of the page. It is one of the eight formatting tabs. The other tabs include "Home", "Layout", "Tables", "Charts", "SmartArt", "Formulas" and "Review".
-
5
Find the "Validate" button and click on it once. A small window will open up on your Excel spreadsheet.
-
6
Make sure that the "Settings" button is highlighted. Under "Validation criteria", and under "Allow", click on the small arrows and choose "List".
-
7
Click in the "Source" box once and then move your mouse or pointer back to the original spreadsheet. Select your entire list on entries or choices and then press the "Return" or "Enter" button on your computer. The source will be filled in.
-
8
On the spreadsheet your cell with have small arrows beside it. Click on the arrows and choose an entry. The entry will show up in the box. Once you have created this dropdown menu you can cut and paste it into many other cells using the traditional cut and paste application.
-
1
