How to Add Values to a Drop Down List

Save

A drop-down list is a useful tool that is commonly used in spreadsheet programs. The list contains a predefined set of values that can be selected in a cell. One spreadsheet program is Microsoft's Excel, which is used for storing, analyzing and organizing data. To populate a drop-down list in Excel 2010, follow a few straightforward steps.

  • Open the database you will be working on in Excel.

  • Select the cells that contain the values to add to the drop-down list. If they do not exist, you can create them in another worksheet or somewhere on the same worksheet. To create the list using another worksheet, type the desired list, then define a name for it. Define a name for the list by highlighting the cells and clicking the name box, which is in the upper left corner of the application directly next to the function box. The box will have the current name of the cell such as "A1." Type a name in the box and press "Enter."

  • Select the cell you want to place the drop-down list in.

  • Click the "Data Validation" tool in that "Data" tab. Click the "Data Validation" button and select "Data Validation" from the drop-down list.

  • Select "List" in the "Allow" box.

  • Select the cells from the button next to "Source" if the list will be from the current worksheet. If the list will be from another worksheet, type "=" and then the name of the list.

  • Click "OK."

References

Promoted By Zergnet

Comments

You May Also Like

  • How to Create a Chart in VBA Excel

    Knowing how to dynamically create charts with Visual Basic for Applications can save time when analyzing large amounts of data. Microsoft Excel...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!