how do you add a drop down menu in excel 2016

You can still use a data range for the list, but the populated drop-down won’t update when you update the list items.

However, the Table object isn’t available in the older menu versions (.xls) so some of this article won’t apply if you’re still using an.

For your convenience, you can download the demonstration. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use an earlier version. SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic) In this article, I’ll show you a quick and easy way to create a drop-down list using Excel’s Data Validation feature. Using a drop-down limits the entry choices for a selected cell, speeding data entry and reducing data entry error.

Press with left mouse button on 'Data Validation.An Excel drop-down list can make it easier for the average Microsoft Excel user to enter data.

Press with left mouse button on 'Data Validation' button.Here is how I created the drop down lists: Create a drop down list for years I will show you later in this post how to set it up. You can use conditional formatting to hide the day when that scenario happens, that will clearly inform the user that the date is not valid. The problem is that there are not 31 days in February. You can select a year and month and a formula calculates the right number of days in the last drop down list, however if you choose 'January' and day 31 and then selects February which is possible. You can copy the drop-down lists and paste anywhere in the workbook but they have to be in the same order and adjacent.

The drop down calendar in the image above uses a 'calculation' sheet and a named range. Author: Oscar Cronquist Article last updated on January 10, 2019

How do you add a drop down menu in excel 2016