Choose an option from the Style box which you find appropriate for you. To do this Go to Error Aler t tab.Ĭheck the box beside “Show error alert after invalid data is entered”. Users can also put an Error Alert if the data entered is invalid. You can uncheck the box if you don’t want any message to be shown when cell is clicked. Type the input message you want to display. Check the “Show input message when cell is selected.” Go to Input tab if you want to enter a popup message when the cell is clicked. In Source box, type equal sign (=) followed by the name of the range that we have given to it earlier. On the Settings tab, in the Allow box, click List.Ĭheck both the boxes beside the Allow box, Ignore blank and In-cell dropdown. Press Alt + A + V + V which is the keyboard shortcut for Data Validation. Drop-down List with Input message and Error Alert You will not be able to link this range if the name of the range contains a space. If there are two words write them without space. Make sure that name of the range should not contain any spaces.
Here we will give the name to the range as Employees. In the Name box, give a name according to your data. Secondly, select the data, right-click, and then click on “Name a range”. Sort the data according to the type of data, either alphabetically or numerically. We will try to create a drop-down list of employees of a company.įirst and foremost, write the names of the employees in column A of your sheet. Let us create a drop-down list with advanced data validations.īefore we proceed to start the process of creating a dropdown list we need some data of which we will create the list from. You can also make a drop-down list with advanced data validations such as it accepts only a numbers or text, to display a warning message when data doesn’t match etc.
#CREATE DROP DOWN LIST IN EXCEL HOW TO#
Isn’t it simple?Ībove, we discussed how to create a simple dropdown list. In other words, you need not have to create a special table for data to insert in the drop-down list. You can directly type into the source box if the list you want to create is just yes/no, a/b/c/d. In the Source Box either select the data from your desired sheet. On the Settings tab, in the Allow box, click List.ģ.
#CREATE DROP DOWN LIST IN EXCEL PROFESSIONAL#
These shortcuts help you save time and projects you like a professional in front of your colleagues.Ģ. I personally prefer to use the keyboard shortcuts. In the Ribbon go to Data Tab, in the Data tools select Data Validation. You can do the same by a long process also. Open your workbook in which you want to enter the drop-down list and follow the steps given below:ġ. It might seem weird but it’s really that easy. You can create a Drop-down list in just 3 easy steps which might take about 30-40 seconds of your time.