There are a lot of applications and websites available to maintain your organization and the task, but to get raw data energy, nothing excels Microsoft Excel -For frequent tasks, their drop -down lists are a real change in the game.
Whether you wander in side bustle, or keep signs of a tab on the family schedules, or just an attempt to understand a mountain of numbers, the drop -down menus is a gift from God rushing to writing. They can also reduce typographical errors and keep everything look elegant.
also: How to use ChatGPT to write Excel formulas
Here’s how to add it to Excel Fast – as well as a few expert tips to adjust and design the drop -down as your desire.
How to add drop lists in Excel
What you will needYou will need to subscribe to Microsoft 365 to use Excel, whether you are on the web or desktop application. I am working on the desktop version here, so if your list looks different online, Microsoft Support Site It can help you fill the gaps. And yes, Google (and other tools) also have droppings, but the setup steps are not completely the same.
https://www.youtube.com/watch?
This article uses a premium for example to show the best how to create a drop -down. In our example, column A maintains customer names, and the b shame is for their communication preferences. Distinguish the cells in the B-column B- Because this is where you will need to skip the drop-down between the email, the phone call, or a text message for each customer.
Also: How to remove Copilot from the Microsoft 365 plan
It shows more
Select the cells where you want dropped.
Maria Diaz / Ilis Boss
Go to the data tab in the menu bar, then click Verify Data Venex (on Mac or the web, may say validation). You will see the data check -in dialog box floating on the roof – this is where magic occurs.
It shows more
Determine the validity of the data in the list.
Maria Diaz / Ilis Boss
On the “Settings” tab from the popup, look for the drop -down menu to allow dropping and choosing the list.
It shows more
Select the menu as health verification standards.
Maria Diaz / Ilis Boss
Enter your drop -down values.
Maria Diaz / Ilis Boss
When you click OK in the popup verification of the authenticity of the data to save your changes, Excel will enter your options directly into the paper. You will see a small arrow next to each cell-click it to open the drop-down menu and choose an option. All you choose will fill the cell immediately, no need to write.
It shows more
Click “OK” to create a drop -down.
Maria Diaz / Ilis Boss
Can you edit a drop -down menu yet?
definitely. You only need to highlight the cells, return to data> Check the health of the data, and adjust the list of items in the source box.
also: How to use the advanced data analysis from Chatgpt to create high -quality schemes and tables
Professional advice: If you have a longer menu (or you want to modify your options easily later), you can write it in a column on another paper and then direct the source field to verify the validity of the data to this range (for example = sheet1! D1: D10).
Is there an end to the number of elements?
Excel allows you to add more than 30,000 options to a drop-down menu-but to scrolling through many options is a real routine action. If you have a huge menu, try dividing it into categories or using the smaller few processes so that it is easier.
Do you want to create yes/not dropping?
Yes, it is used/not an output in the process that we followed for example. You only need to change what you put in the source field to say, “Yes, no.”
- Select the cells you want to contain drop -down menus.
- Click on Data> Check Data Check or Check Health from the menu bar.
- On the “Settings” tab from the data verification window, select the menu within the allowance for health verification standards.
- Enter “Yes, No” in the source field on the popup, separated by a comma only, not distances.
- Click “OK” in “Check Data Correct” to save the “Yes/No” menu.
Can you add colors to the drop -down menu?
Yes. You can use conditional format to apply colors to cells.
- Create your drop -down menu using the authenticity of the data.
- Select the cells that contain the drop -down menu.
- Open the police format by going home, then the police format, and choose a new base.
- Set a value base by choosing “only the cell format that contains”, when entering a value, and set a color through coordination and filling.
- Repeat other drop -down options.
- Click “OK” to save and apply color coding.
Is there a formula to create a drop -down?
no. There is no need for a formula to create drop -down lists in Excel. All you have to do is use the data verification list.
Is the drop -down the same data liquidation?
People are often mixed in liquidation with a drop -down, but they are not the same. Features sit in your heads of columns so that you can hide or show rows-say according to the month, name or site-while the drop-down lists live within the individual cells, allowing you to choose a value to enter.
Can you use Copilot to create drop -down?
No, Copilot in Excel does not allow you to prepare Dooveval Dovereval lists directly via a router. You still need to use the authentic data verification feature from Excel to enter these lists in your spreadsheet.
Get the best stories in the morning in your inbox every day with Technology newsletter today.
