QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Create a Drop-Down List in MS Excel 2016?

By Neha T 1 Comment

To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of  How to Create a Drop-Down List in MS Excel 2016?

Steps to Create a Drop-Down List in MS Excel 2016:

Step 1: In the image below you can see that I have prepared an Excel sheet which contains Sr no., Name and City columns. Now I want to create a drop-down list for the City column.  I have also prepared the list of cities which I want in the drop-down list in the same Excel sheet. If you want, you can prepare the content of drop-down list in the separate sheet also.

Now, select the cell to which you want to convert into a drop-down cell.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-1Step 2: Go the Data tab. Under Data Tools group you have Data Validation drop-down button, click it. Select Data Validation from the options.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-2

Step 3: A Data Validation Dialog box is opened. Under Settings tab, you have Allow: drop down box click it and among the options select List.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-3Step 4: After you select List, a Source fill box appears. Click inside the source box.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-4Step 5: After you click inside the Source box, select the content of which you want to create a drop-down list. You will see that inside Source box the code for the content is generated. Click OK.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-5Step 6: Now you can see that the cell you selected in step 1, is converted to a drop-down cell. Click on the drop-down arrow that appears on the right-hand-side of the cell and the entire drop-down list will appear.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-6Step 7: Now, if you want to apply data validation to all the cells below the City cell. Just drag the Autofill handle of the drop-down cell up to the cell you want to apply data validation.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-7Hence by doing this, you can make all the selected cells as the drop-down cells.

Or

The other method to apply data validation to the other cells connected to data validated cell is, select the cells including the data validated cell. Go the Home tab, Under Editing group you have Fill drop-down button. Click Fill button and as I have selected the cells in the vertically downward manner, I selected Down. If you have selected the cells in horizontal, you can choose Right or Left according to your requirement. In this way, you can apply data validation to adjacent cells in bulk.

how-to-create-a-drop-down-list-in-ms-excel-2016-step-7-1Hope the content is useful. Keep reading.

You Might Also Like:

how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? Auto Fill in MS Excel 2016How to use Autofill in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? Edit a Drop-Down List featured ImageHow to Edit Dropdown List In Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-create-links-in-ms-excel-2016-featured-imageHow to create Links in MS Excel 2016?

Comments

  1. Karen says

    September 19, 2017 at 12:12 pm

    This works great! Thank you. However, I have a huge list in the drop down. How can I type in the box to filter my selection in the drop down?

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Disable Control Panel in Windows 7
  • How to Enable / Disable Regedit in Windows 7
  • How to Hide & Show Files and Folders in Ubuntu
  • How to Check Ubuntu Version
  • How to Backup Messages in WhatsApp?

Copyright © 2023 · QueHow · Contact Us