Browse » Home
Saturday, December 15, 2012
How to Build Drop
1. Scroll to the area of the spreadsheet where you want to create the drop-down list's contents. You build a drop-down list menu in Excel from data typed into any set of cells. If you want this to be inconspicuous to the Excel user, do not use the beginning of the spreadsheet. Instead, you can scroll to the right several columns or scroll down many rows to a less obvious part of the spreadsheet.
2. Type the list you want in your drop-down list menu. You can either type the list as a series of vertical cells, all in the same column, or as a horizontal list, all in the same row. For example, if you selected cell P100 as the starting point for your list, you can type each list item into P100, P101 and P102 (or into P100, Q100 and R100) and continue the list for as long as necessary.
3. Click in the cell or cells where you want your drop-down list menu to appear, based on the typed list elsewhere in the spreadsheet. If you want multiple cells to have the menu, drag your mouse over all of them so they are all selected.
4. Click on the 'Data' menu and the 'Data Tools' section. Then, click 'Data Validation' and select 'Data Validation.' In versions of Excel prior to 2007, click the 'Data' menu and select the 'Validation' option. A pop-up box will appear.
5. Click the drop-down menu on the 'Settings' tab of the pop-up window. Select the 'List' option.
6. Click in the 'Source' field.
7. Drag your mouse over the cells in your spreadsheet that contain the list of items that you typed earlier.
8. Type the 'OK' button to complete the drop-down menu setup.