• About Us
  • Contact Us
  • Today Headline
  • Write for us
Today Headline
No Result
View All Result
  • breaking news today
    • Politics news
    • Sports
    • Science News & Society
  • Entertainment News
    • Movie
    • Gaming
  • Technology News
    • Automotive
    • Software & IT
  • Health News
    • Lifestyle
    • Insurance
  • Finance News
    • Money
  • Enterprise
  • Contact Us
  • breaking news today
    • Politics news
    • Sports
    • Science News & Society
  • Entertainment News
    • Movie
    • Gaming
  • Technology News
    • Automotive
    • Software & IT
  • Health News
    • Lifestyle
    • Insurance
  • Finance News
    • Money
  • Enterprise
  • Contact Us
No Result
View All Result
TodayHeadline
No Result
View All Result

How to create a drop-down list in Excel

June 6, 2022
in Enterprise
Reading Time: 3 mins read


Whether you’re running a business or running a home, keeping things organized is key to success. There are tons of apps and websites to help you stay organized nowadays, but I always come back to old faithful: Microsoft Excel. I just can’t seem to break up with it.

Microsoft Excel is more than just what your parents used at their desk jobs. When used effectively, it can be a rewarding tool in your arsenal, whether you’re running a business, a home, or simply need a budget. Drop-down lists simplify data input, which is helpful where time is money.

How to create drop-down lists in Excel

Drop down lists in Microsoft Excel

Drop-down lists save time when entering data

Image: Maria Diaz / ZDNet

1. Select the cells where the drop-down lists are needed

Selected cells to add drop down lists

Image: Maria Diaz / ZDNet

In this example spreadsheet, there’s a list of clients on the left and a column with Communication Preference on the right. We’ll add drop-down lists for their communication preference, to select whether they want to be emailed, called, or texted.

2. Go to Data in your options, then select Data Validation

Go to Data and select Data Validation

Image: Maria Diaz / ZDNet

A Data Validation pop-up will appear after you click on Data Validation.

3. Under Allowselect List from the menu

Step 3: Under Allow, select List

Image: Maria Diaz / ZDNet

In the Data Validation pop-up, go to the drop-down menu under Allow and select List.

4. In Sourceenter the items for your drop-down lists, separated by a comma

Step 4: Enter data for the drop down list

Image: Maria Diaz / ZDNet

Enter the items you want to be able to choose from in your drop-down lists, each one separated by a comma.

5. Drop-down lists are ready!

Step 4: Enter data for the drop down list

Image: Maria Diaz / ZDNet

Whenever a cell is clicked on, a drop-down arrow will appear on the lower-right corner, click on the arrow and the drop-down list appears to select from. When you select an item from the list, it will populate the cell.

FAQs

Do I need a formula to create drop-down lists?

No formula is needed, all you need to do is change how the type of data input, from typing to selecting. So just going to Data and altering Data Validation will do it, like the steps above.

Is a drop-down list the same as data filtering?

Though they are often mistaken, Data Filtering is different from drop-down lists. Data filtering is added to the headers of each column, so you can filter the visible data by category. For example, filter by month, place, and more. However, a drop-down list lets users select an item to fill the cell with.

  • Trending
  • Comments
  • Latest
development

How The Development of Cryptocurrency Led to the Development of Online Games?

dc young fly mourns jacky oh death in heartfelt tribute 1200x675 – TodayHeadline

D.C. Young Fly Mourns Jacky Oh’s Death In Heartfelt Tribute

1686244042 Homeowners Lose Equity For 1st Time In Over A Decade – TodayHeadline

Homeowners Lose Equity For 1st Time In Over A Decade: Report

2023 06 07T164506Z 708315926 RC2GE1A9C2MT RTRMADP 3 USA SAUDI 1686246526 – TodayHeadline

‘Enduring commitment’: Key takeaways from US-GCC joint statement | GCC News

Cryptocom suspends institutional exchange services in the US – TodayHeadline

Crypto.com suspends institutional exchange services in the US

Keysight SC – TodayHeadline

Charged EVs | How to emulate EVs, charging stations, and power supplies to validate interoperability

attachment creed iii mbj 1 – TodayHeadline

‘Creed III’ Is Now on Streaming

Schrodingers Cat Code scaled – TodayHeadline

Quantum Computing Breakthrough for Better Qubits

PopularStories

Cryptocom suspends institutional exchange services in the US – TodayHeadline
Finance News

Crypto.com suspends institutional exchange services in the US

Keysight SC – TodayHeadline
Automotive

Charged EVs | How to emulate EVs, charging stations, and power supplies to validate interoperability

attachment creed iii mbj 1 – TodayHeadline
Movie

‘Creed III’ Is Now on Streaming

Schrodingers Cat Code scaled – TodayHeadline
Science News & Society

Quantum Computing Breakthrough for Better Qubits

About Us

Todayheadline the independent news and topics discovery
A home-grown and independent news and topic aggregation . displays breaking news linking to news websites all around the world.

Follow Us

Latest News

Cryptocom suspends institutional exchange services in the US – TodayHeadline

Crypto.com suspends institutional exchange services in the US

Keysight SC – TodayHeadline

Charged EVs | How to emulate EVs, charging stations, and power supplies to validate interoperability

attachment creed iii mbj 1 – TodayHeadline

‘Creed III’ Is Now on Streaming

Cryptocom suspends institutional exchange services in the US – TodayHeadline

Crypto.com suspends institutional exchange services in the US

Keysight SC – TodayHeadline

Charged EVs | How to emulate EVs, charging stations, and power supplies to validate interoperability

attachment creed iii mbj 1 – TodayHeadline

‘Creed III’ Is Now on Streaming

  • Real Estate
  • Parenting
  • Cooking
  • NFL Games On TV Today
  • Travel and Tourism
  • Home & Garden
  • Pets
  • Privacy & Policy
  • Contact
  • About

© 2023 All rights are reserved Today headline

No Result
View All Result
  • Real Estate
  • Parenting
  • Cooking
  • NFL Games On TV Today
  • Travel and Tourism
  • Home & Garden
  • Pets
  • Privacy & Policy
  • Contact
  • About

© 2023 All rights are reserved Today headline