Select the entire column by clicking the letter at the top or the entire row by clicking the number on the left. If you want to use the same drop-down list options across a whole column or row, that’s simple enough. The pop-up window will disappear, and you should see that the cell for your drop-down list contains an arrow for you to select an item. 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.
How to add drop down menu in excel 2016 how to#
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.
How to add drop down menu in excel 2016 mac#
Select a different color from the drop-down list to see the result.Using custom lists in Microsoft Excel on your Mac makes tedious data entry relatively quick and easy. Click Add another rule to add the rest of the Conditional Format rules to the drop-down list.With the cell that contains the drop-down list selected, select Format > Conditional formatting from the Menu.Tick Show dropdown list in cell if it not already ticked and then click Save.Make sure the Cell range is where the drop-down list should go, and then select the Criteria range (e.g., B3:B6).In the Menu, select Data > Data validation.The process to add a drop-down list with color formatting is much the same in Google Sheets as it is in Excel. The Conditional Formatting Rules Manager should end up having four rules all applying to the cell containing the drop-down list (e.g., D2).Īdd a Drop-Down List With Color Formatting in Google Sheets Create rules for Yellow, Green, and Blue by following the same steps.Select the drop-down list and change the value to Red to see the result of the Conditional Formatting.Click OK to return to the New Rule screen and then OK to show the Rules Manager.Select the Fill tab and select the color (in this case, red). Click on the Format... button to set the format.Select New Rule, and then select Format only cells that contain.Select the cell that contains the drop-down list, and then in the Ribbon, select Home > Styles > Conditional Formatting.Click OK to see the drop-down list in the workbook.Īmend the Background Color With Conditional Formatting.Select the range of cells with items as the Source.In the Ribbon, select Data > Data Tools > Data Validation.To make a drop-down list from the data contained in a range of cells, start by selecting the cell where you want the drop down to appear. Create a Drop-Down List With Data Validation To create a drop-down list where the background color depends on the text selected, start with Data Validation in Excel, then use Conditional Formatting to amend the background color. This tutorial will demonstrate how to add a drop-down list with color formatting in Excel and Google Sheets.