Buzz
Creating lists in Excel allows users to select data to input into cells from a pre-set list, ensuring consistent data presentation and easy filtering based on each item in the list.
An Overview of Excel and Its Benefits
Microsoft Excel is a versatile and widely-used spreadsheet tool, an indispensable part of the Microsoft Office suite of applications. Excel not only helps users easily manage and manipulate data but also provides powerful and flexible data analysis capabilities.
When it comes to data management, Excel offers functions such as sorting and filtering, making it easy for users to search for and organize information. The built-in formulas and functions allow for a range of calculations, from basic arithmetic operations like addition, subtraction, multiplication, division, to more complex operations like finding average values, consolidating data, and even solving mathematical equations.
Excel is not only powerful in terms of numerical data but also supports users in visualizing data through charts and graphics. From column charts, line charts to pie charts, users can choose from a variety of chart types to represent their data vividly and comprehensibly. Excel also supports online sharing and collaboration, allowing multiple people to work on a document simultaneously, ensuring everyone has the latest information and stays synchronized.
What is a Drop List? When to Use Drop Lists?
A Drop List, also known as a dropdown list, is a data format type used for various convenient and useful purposes such as:
- Creating categories for quick input into empty cells.
- Suitable for locations requiring personal information gathering in large quantities.
- Facilitating declaration, attendance tracking in organizations, groups,...
- Business management through Drop Lists is also very convenient.
How to Create Drop Lists in Excel using Data Validation
Step 1: Excel file=>Cell for creating Drop List=>Data tab=>Data Validation.
Step 2Settings tab=> List 
Step 3Sources section=>Drag select the cells you want to create the Drop List =>OKcreating Drop List in Excel
Step 4
Create List Box in Excel with dependency on another list
This method will help you retrieve a list related to the words entered in another list.
Step 1
Step 2: Perform naming steps for Provinces as follows:
Select=>right-click=>Name Definition=>enter the names of corresponding provinces
enter the names of corresponding provincesNote: The names of the Provinces must be set to match the names of the Provinces already entered + without spaces.
Example:
Select from B1 to B7: Name it QuangNinh.
Select from C1 to C5: Name it HaiPhong.
Select from D1 to D7:
Step 3:Cell requiring Drop List=>Data tab=>Data Validation
Step 4:=> Configuration=>Allow section=>ListIn the Source section, input the following formula: =INDIRECT(SUBSTITUTE(C11;' ';'')) => Press OK.
Function Explanation:SUBSTITUTE(C11;' ';''): Data is taken from cell C11 and spaces between words are removed to match the name you set in step 2.
INDIRECT Function:
Step 5
How to Delete Drop Lists in Excel
Step 1: Cell formatted with Drop List=>Home tab
Step 2 Modification=>Clear=>Clear All
Conclusion:Here are several ways to help you create Drop Lists in Excel shared by Mytour. If you find this article helpful, please share it with your friends and family. Wish you success!
- See also: Windows Tips and Tricks, Basic Excel Tricks
