Select Multiple Items from a Drop Down List in Excel
Now and again, it’s difficult to tell which cells contain the drop-down list. Thus, it’s a good idea to stamp these cells by either giving them an unmistakable boundary or a foundation tone. Rather than physically checking every one of the phones, there is a fast method for choosing every one of the phones that has drop-down records (or any information approval rule) in it.
Step 1: Go to the Home Tab, Select Find and Select, and Choose Go to Special
- Go to Home –> Find & Select –> Go To Special.
Step 2: Select Data Validation and Click OK
- In the Go To Special exchange box, select Data Validation. Click OK.
- Information approval has two choices: All and the Same. All would choose every one of the cells that have an information approval rule applied to it. The same would choose just those cells that have similar information approval as that of the dynamic cell.
How to Create a Drop-Down List in Excel
A drop-down list offers users a selection from predefined options, commonly used on sites/applications for easy navigation. Dynamic arrays in Excel 365 allow us to create drop-down lists quickly, without complex setups.
Contact Us