how do i add a drop down menu in excel 2016

Then, under the “FORMULAS” tab, click on “Create from Selection.To do so, right-click the table and select table>convert to range. We need to select the above data range to name this date range Date Range To create a data range in Excel, click anywhere in the table and then go to table tools>design on the ribbon>convert to range.We must create a start date and end date like the one below.To name a range, first select the range of data and then insert a table to the range, then put a name to the range from the name box on the left-hand side of the window.

Then, we need to create named ranges Named Ranges Name range in Excel is a name given to a range for the future reference. In the above example, we have directly supplied the start and end date, but imagine the scenario where we need to change the start and end date frequently.

So, like this, we can create data validation to restrict users from entering dates between specific ranges.Įxample #2 – Create a Named Range for Start & End Date When we inserted the date between the start and end date, it accepted the value. Now, enter the date between 01st Jan 2020 to 31st Jan 2020.When we tried entering the value as “hello,” it gave us the warning message, “This value doesn’t match the data validation restrictions defined for this cell.” However, we do not see any drop-down lists in the selected cell.

Finally, click on “OK,” and we will exit the data validation window.

Assume we need to create data validation from 01st Jan 2020 to 31st Jan 2020, then enter the start and end date as shown below.

Once the “Date” is chosen, we must enter “Start Date & End Date.”.

So click on the drop-down list of “Allow:” and select “Date.”

We need to choose what kind of validation we will create for the drop-down list.

If you are a fan of a shortcut key, we can press the shortcut Excel key “ALT + A + V + V” to open the above “Data Validation” window instead of going through the above steps.

It will bring below the “Data Validation” window.

Now, we must click on “Data Validation” under the “DATA” tab.

First, we must select the cell where we need to create a drop-down list.

How do i add a drop down menu in excel 2016