Whatsapp Group |
Whatsapp Channel |
Telegram channel |
How to create dropdown in MS Excel
Create a Dropdown List :
To create a drop down List in MS Excel you have to execute the following steps:
- Type the Item on the second sheet that you want to appear in the drop down list.
![Excel Create a Dropdown List](https://reoranjantech.com/wp-content/uploads/2020/04/Create-a-Dropdown-List.png)
Note: if you don’t want users to access the items on the second sheet you can hide the second sheet. To achieve this right-click on the second sheet and click on hide.
![How to create dropdown in MS Excel](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-create-dropdown-in-MS-Excel.jpg)
- Select cell B1 on the first sheet.
![How to create dropdown in MS Excel](https://reoranjantech.com/wp-content/uploads/2020/04/3-2-1.png)
- On the Data tab click the Data Validation in the Data Tools Group.
![conditional drop down list excel](https://reoranjantech.com/wp-content/uploads/2020/04/conditional-drop-down-list-excel.jpg)
The ‘Data Validation’ dialog box appears just like above given.
- Click List in the Allow box.
- Click in the Source box and select the range A1: A3 on the second Sheet.
![how to create drop-down list in excel 2020](https://reoranjantech.com/wp-content/uploads/2020/04/how-to-create-drop-down-list-in-excel-2020.jpg)
- Click ok button.
Result:
![excel drop down list multiple selection](https://reoranjantech.com/wp-content/uploads/2020/04/excel-drop-down-list-multiple-selection.png)
Note: To copy and paste a drop-down list, select the cell with the drop-down list and press CTRL+c, and another cell press CTRL+v.
- You can also type the items directly into the source box, instead of using a range reference.
![excel formula based on drop down list](https://reoranjantech.com/wp-content/uploads/2020/04/excel-formula-based-on-drop-down-list.jpg)
Note: this makes drop down list case sensitive.
Allow other Entries
You can also create a drop down list in excel that allows some other entries.
- When you type a value that is not in the list, Excel shows an errors alert.
![How to Create Dynamic Drop Down List in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-Create-Dynamic-Drop-Down-List-in-Excel.jpg)
To allow other entries, execute the following steps:
- On the Data tab, click the Data Validation in the Data Tools group.
![Creating a drop-down list in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/Creating-a-drop-down-list-in-Excel.jpg)
The ‘Data Validation’ dialog box appears just like above given.
- On the Alert tab, uncheck ‘Show error alert after invalid data is entered’.
![](https://reoranjantech.com/wp-content/uploads/2020/05/10-3.png)
- Click ok button.
- Now you can enter a value that is not in the list.
![How to create a drop-down menu in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-create-a-drop-down-menu-in-Excel.jpg)
Add/Remove items
You can add or remove items from a drop-down list in MS Excel without opening the ‘Data Validation’ dialog box and change the range reference. By this you can save your time.
- To add an item, go to the items on second Sheet and select the item.
![How to create a drop-down list in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-create-a-drop-down-list-in-Excel.jpg)
- Right click on that item and click insert.
![How to Create Drop Down Lists in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-Create-Drop-Down-Lists-in-Excel.jpg)
- Select the “Shift cells Down” and then Click Ok.
![How to Create a Drop Down List](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-Create-a-Drop-Down-List.jpg)
Result:
![Create a Drop Down List in Excel](https://reoranjantech.com/wp-content/uploads/2020/04/Create-a-Drop-Down-List-in-Excel.jpg)
- Type a new item.
![How to Create Drop Down Lists in Cells](https://reoranjantech.com/wp-content/uploads/2020/04/How-to-Create-Drop-Down-Lists-in-Cells.jpg)
- If you want to remove an item from a drop down list, click Delete, select “Shift cells up: and then click OK.
How to create dropdown in MS Excel
- Read More:-