• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Creating a drop-down list in Excel is simple in 1 minute

0 Comments

Creating a dropdown list in Excel is one of the great ways to impress your boss and colleagues in the workplace. In this article, Buffcom.net will show you 5 simple steps to create a dropdown list in Excel.

Creating a dropdown list in Excel

Microsoft Excel is a powerful spreadsheet software that is widely used for various data-related tasks such as filtering data, sorting data by alphabetical or numerical order, etc. In this article, Buffcom.net will focus on a very useful feature – creating a dropdown list in Excel.

If you are still wondering what a “dropdown list” is, the illustration below will give you an idea of how it works. In this article, Buffcom.net will explain briefly what a dropdown list is and provide a guide on how to create a dropdown list in Excel.

A dropdown list is actually a small window that, when clicked, will drop down a list of different options for you to select quickly.

A dropdown list also provides you with the ability to control exactly what is entered into an Excel cell. This makes the dropdown list a very powerful and popular data validation tool.

Fortunately, creating a dropdown list in Excel is actually very easy if you follow the steps below.

*This tutorial uses Excel 2019/Microsoft 365 (Windows OS). If you use a different version, you can still use the steps below to create a dropdown list in Excel.

First, we have a sheet with all the names of employees in the company.

This is what we will see when we click on a dropdown list.

tao danh sach tha xuong trong excel 1Then, we will have a “small arrow” right next to the cell. When we click on it, it will open a window containing the name data as shown in the image above. You can scroll up and down to browse through the employee name list in the entire sheet, and all of it will be wrapped up in a dropdown list cell.

Now, we will create a dropdown list in cell B1.

Step 1: Click on the “Data” tab.

This step is very easy to perform!

You just need to simply hover your mouse over the “Data” tab and click on it.

tao danh sach tha xuong trong excel 2Step 2: Click “Data Validation.”

Click on the “Data validation” button in the middle of the ribbon (don’t click on the small arrow next to the word “Validation” – simply click on the top part of the button as illustrated in the picture) to create a drop-down list in Excel.

tao danh sach tha xuong trong excel 3Step 3: Select the “List” option.

In the dialog box that appears, you need to click on the drop-down list to select the data validation method you want.

Click on the down arrow in the “Allow” field, and in the drop-down list, click on “List”.

tao danh sach tha xuong trong excel 4Step 4: Choose the data source to put into the list.

Do you remember the sheet cells containing data that were mentioned at the beginning of the article?

The sheet cells containing the names of all employees in the company will be used as the input data source for the drop-down list.

Now it’s time to declare the data in the range of cells so that Excel can connect the source data (employee names in the sheet) with the drop-down list cell (cell B1).

Click on the “Source:” data field.

Then, click and select all the name data in the sheet.

Click “OK” when done.

tao danh sach tha xuong trong excel 6Tip to help you quickly select the entire range of cells without having to drag the mouse like the picture above.

Click on the first data cell (in this case, A2) and then hold down Ctrl + Shift + Down arrow. This will help you quickly select a range of cells in less than a second.

Step 5: The result of the execution!

tao danh sach tha xuong trong excel 7And here is the result of your labor, isn’t it quick and easy?

Above, Buffcom.net has instructed you on how to create a drop-down list in Excel in less than a minute (sometimes less than that). If you are proficient in the above steps, it may only take 10-15 seconds to complete a list like this.

If you find this article useful, please Like & Share to support the team, or leave a comment below to discuss if you have other methods.

Rate this post
36
267 Views
How to round currency values easily in ExcelPrevHow to round currency values easily in ExcelMarch 3, 2023
6 Ways to Fix "The File is Corrupted and Cannot be Opened" Error in Excel, WordMarch 3, 20236 Ways to Fix "The File is Corrupted and Cannot be Opened" Error in Excel, WordNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
Products
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Windows Server 2016 Standard Key Global Windows Server 2016 Standard Key Global
    Rated 4.80 out of 5
    $10.00
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Microsoft Visio 2019 Professional Key Global Microsoft Visio 2019 Professional Key Global - 5 PC
    Rated 4.93 out of 5
    $19.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Windows 10 Pro OEM Key Global - Reinstalling win is still active Windows 10 Pro OEM Key Global - Reinstalling win is still active
    Rated 4.88 out of 5
    $6.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Windows 10 Enterprise Key Global Windows 10 Enterprise Key Global
    Rated 4.82 out of 5
    $9.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • Project Professional 2010 Microsoft Project Professional 2010 - 1PC $9.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.