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.
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.If you’ve found this tutorial helpful, like us and subscribe to receive more videos from Eas圜lick Academy. When both options are in, click on OK and the job is done! The simple drop-down list has been created! Then we’ll click on the ‘Data’ tab, go to ‘Data Tools’ and find ‘Data Validation’.Īgain, we’ll select the ‘List’ option, but now we’ll just type into the box two words – ‘Yes’ and ‘No’ – separated with a comma. We’ll have a look the second question, where, in the part ‘Your answer’, there will be just ‘Yes’ or ‘No’.Īs you already know, the first step will be selecting the cell in which we want to create the drop-down list.
HOW TO ADD A DROP DOWN MENU IN EXCEL 2016 HOW TO
Well, let’s move on and see how to create a short drop-down menu made of only two options. How to Create a Short Drop-Down List in Excel If anyone tries to type in a different option, Excel will not allow it. Press ‘Enter’ – and you’ve defined the contents of your drop-down list!Ĭlick on OK and you’re done! The column with ‘Your answer’ now contains a drop-down list from which you can choose your favourite month.Īs soon as you create the list, you can pick only from the options you’ve defined. Here we’ll click through to the spreadsheet ‘Months’ and select all months we want to include in the list. Click on the icon on the right of the ‘Source’ box. Now you need to tell Excel where to find the data for the drop-down list. Then click on the tab ‘Data’, go to ‘Data Tools’ and select the option ‘Data Validation’.įind ‘Settings’ in the pop-up window and select ‘List’ from the menu. Now we’ll click back on the spreadsheet ‘Questionnaire’ and create our first drop-down list.Ĭlick into the cell in which you want to create the drop-down menu. I myself added a new spreadsheet, named it ‘Months’, and made a list of months that’ll be used for our drop-down menu. So, if you want to make a drop-down menu with more options, it might be a good idea to create the list somewhere else, for example in a different spreadsheet. The answer to the first question will be a specific month of the year. How to Create a Longer Drop-Down List in Excel Those will be possible answers to our second question.īut let’s start from the beginning now. I’ll show you a way how to create a short drop-down list with only two items – ‘Yes’ and ‘No’. Then we’ll try something a little bit different. They’ll become our options for the answer to the first question. What we can use for drop-down items here are the months of the year. We’ll use this short questionnaire to see how simple it is to create a drop-down menu and you’ll be able to use these steps to create a list with any data you need.įirst, we’ll have a look at how to create a longer drop-down list with more options.
2 How to Create a Short Drop-Down List in Excel
0 kommentar(er)
