how do you add a drop down menu in excel 2016

We need that the user has to select from this list.Ĭlick Data > Data Validation option in Excel 2016ĭata Validation dialog box appears as shown above. Here is a list of three colours Red, Green and Blue. We will be using Conditional Formatting and Data Validation options.įirst, let’s understand how to make a dropdown list in Excel with an example here Then, select the cell to the right of a dropdown list and go to the Insert tab.In this article, we will learn how to create a Dropdown list with color in Microsoft Excel.ĭrop down list limits the user to choose a value from the list provided instead of adding values in sheet. To begin, download the drop-down-arrow.png file (right-click on that link and select Save link as). When selecting the dropdown list, the down arrow button for the list displays over the image we inserted. We're going to insert that image in the cell to the right of the dropdown list, so you see a down arrow button even when the dropdown list is not selected. We took a screenshot of the down arrow button on a dropdown list in Excel. We're going to get around this problem by adding a permanent down arrow button to the right of the dropdown lists. The down arrow button on a dropdown list goes away when the cell is not selected. Make the Dropdown List Arrow Always Visible

If you would rather not apply different formatting to dropdown lists, the next section shows you another way to make them always visible. Now you can format these cells to differentiate them from other cells, so you know where all the dropdown lists are.

How do you add a drop down menu in excel 2016