AskDrexel Home Drexel Home Search. Solution Enter the values you want to have in the drop-down list. Select the cell where you want to have the drop-down list.

Click 'Data', 'Data Validation'. Click 'Collapse dialog', next to 'Source'.

Select range of cells. Knowledge-Paks Online and Knowledge-Paks On Site Copyright c by RightAnswers, Inc. Subject to the terms set forth in the end-user license agreement. Scripting must be enabled to use this site.

Answers Ask a Question My Stuff Account Overview Questions Notifications. Search Advanced Search Search terms. Screen Reader users press enter to Limit by Topic. Limit by Topic This button does not work with screen readers.

Please use the previous link instead. Sort by Default Summary New or Updated Description Date Updated Direction Ascending Descending.

MS Excel Creating a button

Find the answer to your question. Details Microsoft Excel allows you to create your own customized drop-down list. You can insert pre-defined values into a cell. A drop-down arrow appears when you move to a different cell.

How to put more than one filter in Microsoft Excel? - ask Nguyen

To create a drop-down list: The 'Data' tab appears. The 'Data Validation' dialog box appears. The 'Source' box appears. The Data Validation dialog box appears.

The selected range appears in the 'Source' box. The drop-down list appears in the appropriate cell. Did this answer your question?

Please tell us how we can make this answer more useful. Answers others found helpful How to: Set up data sources in Excel Limit cell entries to numeric values in Excel Name a range in Excel Enable automatic completion of cell values in Excel Change cell values into numbers in Excel Share Delicious Digg Facebook Reddit StumbleUpon Twitter. Contact Us Ask a Question Submit a question to our support team.