how to create a drop down menu in excel 2016

When you release the cursor at the end of the cells you’re selecting, the window will maximize again. Note that the pop-up window will minimize as you perform this action. (You can also type in the cell range yourself if you’re comfortable with the format.) You can use a new sheet in your workbook or existing cells where you have the items entered.Ģ) Click the cell where you want to insert the drop-down list.ģ) Open the Data tab and click Data Validation from your ribbon.Ĥ) In the pop-up window, click the Settings button.ĥ) Under Validation criteria > Allow, select List.Ħ) Click inside the Source box and then drag through the cells that should appear in the drop-down list. Then, follow these steps.ġ) Enter your list items onto a spreadsheet. Open Microsoft Excel and the document where you want to add the drop-down list. Here’s how to quickly create a drop-down list in Excel on Mac. They come in handy for selecting items like colors, sizes, products, people, days, and so much more. Drop-down lists are no different you can create one in just a few clicks.ĭrop-down lists in Excel are ideal for limiting the options for cell entries.

Using custom lists in Microsoft Excel on your Mac makes tedious data entry relatively quick and easy.

How to create a drop down menu in excel 2016