Where is drop down menu in excel

To do that, you just need to follow the steps above until Step 4. Then enter every single item for your drop down list, separating each item by a comma. You can use Excel formulas, for example, to create a simple drop down list.

You can even create a dynamic drop down list that can easily be extended when necessary. Michelle Rae Uy is a Los Angeles-based editor, writer and photographer with a bad case of wanderlust. She has written for publications like Nylon, Fodor's and SmarterTravel, and is also the contributing editor for MiniTime.

North America. Then you can use the entries as the source for your drop-down list of data. If the list is not large, you can easily refer to it and type the entries directly into the data validation tool. Create a list of valid entries for the drop-down list, typed on a sheet in a single column or row without blank cells.

Note: If the validation command is unavailable, the sheet might be protected or the workbook may be shared. You cannot change data validation settings if your workbook is shared or your sheet is protected. For more information about workbook protection, see Protect a workbook. Click the Settings tab, and then in the Allow pop-up menu, click List.

Click in the Source box, and then on your sheet, select your list of valid entries. You can also type values directly into the Source box, separated by a comma.

To modify the list of valid entries, simply change the values in the source list or edit the range in the Source box. You can specify your own error message to respond to invalid data inputs. Apply data validation to cells. Now is a good time to Sort your data in the order you want it to appear in your drop-down list.

Go to the Data tab on the Ribbon, then click Data Validation. If you already made a table with the drop-down entries, click in the Source box, and then click and drag the cells that contain those entries.

However, do not include the header cell. Just include the cells that should appear in the drop-down. You can also just type a list of entries in the Source box, separated by a comma like this:.

If you want a message to pop up when the cell is clicked, check the Show message checkbox, and type a title and message in the boxes up to characters.

If you want a message to pop up when someone enters something that's not in your list, check the Show Alert checkbox, pick an option in Type , and type a title and message.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. All Excel functions by category. Creating drop-down lists free preview. Table of contents. Intro to Excel. Create a new workbook Article Insert or delete a worksheet Article Move or copy worksheets or worksheet data Article Print a worksheet or workbook Article Use Excel as your calculator Article Fill data automatically in worksheet cells Article Create a drop-down list Article.

Table of contents Intro to Excel. Enter and format data. Behold its mighty glory! Luckily, creating a drop-down menu is super easy if you know the exact steps. Follow along by downloading our sample file right below! First we have a sheet with all the names of our employees. This is the data we would like to see when opening our drop-down menu.

This step is easy!