• 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
43
273 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
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
Products
  • 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
  • Microsoft Project 2016 professional CD Key Global Microsoft Project 2016 professional CD Key Global
    Rated 4.97 out of 5
    $9.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
  • Windows Server 2025 Datacenter Windows Server 2025 Datacenter $30.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.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
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.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.