How to create drop down lists in Excel
However, not all users know how to create drop down lists in Excel.
Create an Excel drop down list
The steps to create a drop down list are as follows:
Step 1: Create an optional content list.
Step 2: Select a cell or a range of cells for your drop-down list with the same drop-down list content.
Step 3: On the Data tab (1) , click Excel Data Validation (2) .
Step 4: The Data Validation window appears, on the Settings tab , follow these steps:
- In the Allow box , select List .
- In the Source box : enter the location of the area in which you create the drop-down list.
- Select the checkmark in the In-cell dropdown box.
- Select Ignore blanks if you want to allow users to leave the box blank. And do not choose if not allowed.
Click OK and you're done!
The result you get is as follows:
Note: in Step 4 , in the Source section,you can enter the options that you want to appear in your list of options separated by commas for similar results.
Copy and paste the drop down list
If you accidentally selected the drop-down list area in step 2, you can copy the drop-down list following the steps below.
Step 1: Select the cell containing the drop-down list and press Ctrl + C to copy.
Step 2: If you want to copy both the drop down list and the format of the original cell, just select the cell to be copied and press Ctrl + V to copy.
Step 3: If you just want to copy the drop down list and do not include the original format. After copying in Step 1 , select the cell to copy the list, right-click and select Paste Special .
Paste Speacial window appears, select Validation and then click the OK button .
How to select cells containing drop-down lists
Select all the cells containing drop down lists
Because the arrow button does not show on the drop-down list unless that cell is selected, it is difficult to know which cell contains the drop-down list. You can apply different formats to the cells in the drop down list for easy distinction. But first need to find all the drop down lists. There is a way to select all cells containing drop down lists. Select the Home tab (1) and click the arrow under Find & Select (2) in the Editing section, then select Data Validation (3) .
Results of the cells containing the drop down list selected:
Select the cells containing the same drop down list
With the above method, you can select entire drop down lists, but to select cells containing the same drop down list, follow these steps:
Step 1: Select a cell containing the drop-down list, select the Home tab (1) and click the arrow under Find & Select (2) in the Editing section, then select Go To Special . (3) .
Step 2: On the Go To Special window, click the check box as below and then press the OK button .
As a result, only the cells containing the drop-down lists like the ones selected in Step 1 are selected:
Delete a dropdown list in one cell
To delete the dropdown list in a cell, select the cell and go to the Data tab (1) and click Data Validation (2) in the Data Tools section .
Validation window appears, click the Clear All button .
The options on the Data Validation dialog box will be reset to the default values, then click OK .
So the selected cell will delete the drop down list:
Above, Software Tips guide you how to create drop down lists in Excel. Good luck!
You should read it
- How to create drop down lists on Google Sheets
- How to Create a Drop Down List in Excel
- How to create a filter in an Excel cell
- How to create drop down list to select in excel
- How to create bullet list in Excel
- Create Drop cap big letters in Word
- How to create Drop Cap in Word
- How to list conditional lists in Excel
May be interested
- Bullets, Numbering in Wordbullets and numbering lists are used in documents to organize, list and emphasize text. in this article, dexterity software will learn how to use existing symbols (bullet), insert new bullets and numbers, select bullet icons and multi-level list format.
- How to insert characters at the beginning or end of a string in Excelrecently software tips received many questions asking how to insert characters at the beginning or end of a string in excel. so today, dexterity software introduces readers how to insert more characters into the string in this article, invite you to track.
- Wrap text in Wordquite a few users know about the wrap text tool in word that is used to adjust the appearance of images compared to text beautifully. so today, dexterity software will introduce to readers how to insert images and adjust the position of images and text content accordingly!
- How to copy from Excel to Word without frameswhen copying data from excel to word, the software will default to the data accompanying the frame. so in case you just want to copy the data without the accompanying frame?
- How to remove periods in numbers in Excelhow to remove periods in numbers in excel when typing a string of numbers, data entry people have a habit of inserting dots in the middle to easily observe the data and reduce errors when entering data. however, in some cases, the dot will make the calculation impossible.
- How to paste data into non-hidden cells, ignoring hidden cellsthe copy tool - paste is a useful tool in excel. however, to best use this tool, not all users know it. in this article, dexterity software teaches you how to paste data that ignores hidden cells.