How to Add Drop Down Menu in Excel 2016

Are you looking for ways to add a drop-down menu in your Excel 2016 spreadsheet? This tutorial will guide you on how to insert a drop-down calendar, also known as a date picker, and link it to a specific cell. You can follow the same method to create a dropdown list in Google Sheets.

To start, let's first understand what Conditional Formatting and Data Validation options are in Excel 2016. These two tools are very useful for viewing your data in a particular format manner. For instance, you can use Conditional Formatting to highlight cells based on specific conditions.

Now, let's get started with the tutorial. First, create a list of options that you want to present to the user as a dropdown list. In this example, we will be using three colors: Red, Green, and Blue. Select Specific Text option and select the cell for color as in this case, Red.

Next, go to Data > Data Validation option in Excel 2016. The Data Validation dialog box appears as shown above. Here, you need to specify the options that you want to present to the user. Select List in Allow and select the source list in Source option and click OK.

Once you've done this, a dropdown list will be created on the cell. We need that the user has to select from this list. To make it mandatory for the user to select an option from the list, go to Data > Data Validation again and select the cell where you want to display the dropdown list.

In this article, we have learned how to create a Dropdown list with color in Microsoft Excel using Conditional Formatting and Data Validation options. By following these steps, you can add a drop-down menu in your Excel 2016 spreadsheet that limits the user to choose a value from the list provided instead of adding values in the sheet.

We would love to hear from you! Do let us know how we can improve, complement or innovate our work and make it better for you. You can follow us on Twitter and Facebook, and if you liked this blog, share it with your friends on Facebook.

How to add drop down menu in excel 2016