People rely on Microsoft Word and Excel for work.
Step 1: First of all, you gotta create an original sheet that contains the source data.
Then create a destination sheet where you would like the drop-down list to be.
Choose one cell that is going to have the drop-down list.
Step 2: Switch to theDatatab on the ribbon and in theData Toolssection, chooseData Validation.
Step 3: In the pop-up window, under theSettingstab, chooseListin theAllowdrop-down menu and checkIgnore blankandIn-cell dropdown.
The data will be automatically selected and clickOKto save the change.
You will now have a drop-down list menu located in the cell you have chosen.
Here are specific steps.
To add other values to the drop-down list, you could do it as follows.
Step 1: Go to theDatatab and in theData Toolssection, chooseData Validation.
At last, you might enter the value not included in the list.
Step 1: Locate the cell and choose one item from the list.
Step 2: Right-tap on the item and chooseInsert.
Step 3: Check the option ofShift cells downand clickOK.
If you want to remove the item, you could right-snag the item and clickDeletefrom the drop-down menu.
Then selectShift cells upand clickOK.
Step 1: Locate the drop-down menu cell and chooseData ValidationfromData Tools.
Step 2: InSettingsfrom the pop-up window, clickClear Alland thenOK.
This post teaches you how to activate Microsoft Excel app.
4 ways are provided with detailed explanations.
Bottom Line:
There is a detailed introduction to Excel drop-down list.
Multiple types of Excel drop-down lists have been cleared.
More functions and features will be listed by Minitool and you’ve got the option to expect that.
Hope this article can help resolve your concerns.
