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 Edit Dropdown List In Excel 2016?

By Neha T Leave a Comment

In our earlier post, we have discussed the methods to create the drop-down list. In case, you need to edit dropdown list i.e. if you want to add more items to the drop-down list or you want to delete the items from the drop-down list you can do it with few pretty simple steps.  In this section, we will discuss the methods to edit the dropdown list.

We will edit the dropdown list using the three methods as shown below:

      1. Edit Dropdown List separated by Comma
      2. Edit Dropdown List based on Range of Cells
      3. Edit Dropdown List based on Named Range of Cells

Steps to Edit Dropdown List in Excel 2016:

Edit Dropdown List separated by Comma

Step 1: Select the range of cells to which you have applied the dropdown list, as if you will select only one cell from the applied range then the modification will only be applicable to the selected cell only. So, select the entire range of cells to which you have applied the dropdown list.

Edit a Comma Separated Drop-Down List 1

Step 2: Then click on Data Validation from the Data Tools group in the Data tab.

Edit a Comma Separated Drop-Down List 2

Step 3: Data Validation dialog box will open. Under the Setting tab, you have an Allow dropdown list. From the provided options click on ‘List’.

In the Source box edit the list you have created earlier. If you want to add an item to the list add it by separating with a comma or if you want to delete an item, you can delete it with the backspace or delete button.

In the image below you can see that I have added a name ‘Jhona’ in the list separated by a comma. You can add more items at once.

Click OK.

Edit a Comma Separated Drop-Down List 3

Step 4: Now, click on any cell from the range to which you have applied the dropdown list. Click the dropdown arrow, scroll down and see that the item you have added is appearing in the list or the item you have deleted has vanished from the list.

Edit a Comma Separated Drop-Down List 4

Edit Dropdown List based on Range of Cells

Instead of manually adding the items to list separated by comma you can simply create a list of items in excel sheet and select that range of cells in the Source box of Data Validation dialog box.

Step 1:  Come to the range of cells where you have created the list for the drop-down box it can also be in a separate sheet. Now, edit the list. Like I have added a new name ‘Jhona‘ to the list which is in Sheet2 and I have applied the dropdown list in Sheet 4 of the same document.

The list can also be in the same sheet where you have applied the dropdown list.

Edit a Drop-Down List based on range of cells 1

Step 2: Now, select the entire range of cells to which you have applied the dropdown list as you need to apply the modification to every cell in the range.

Now, from the Data tab, select the Data Validation option in the Data Tools group. Data Validation dialog box will open. In the Source box, click the selection (2) button to select the range of cells.

Edit a Drop-Down List based on range of cells 2

Step 3: Select the range of cells which has the modified data for the drop-down list.

Edit a Drop-Down List based on range of cells 3

Step 4: After the modified list is selected. Click OK.

Edit a Drop-Down List based on range of cells 4

Step 5: Click on the down arrow of you drop-down list to confirm that the item we added to list appears in the dropdown list.

Edit a Drop-Down List based on range of cells 5

Edit Dropdown List based on Named Range of Cells

Step 1: Edit the named range of cells which you have added as a source in your dropdown list. Like, I have added Roma to the range of cells which I have named as Staff.

Edit a Drop-Down List based on named range of cells 1

Step 2: Go the Formulas tab, click on Name Manager in the Defined Names group.

Edit a Drop-Down List based on named range of cells 2

Step 3: Name Manager dialog box will open. Under Edit tab click on the named list to which you want to edit. Like, I want to edit the Staff list so, I clicked Staff.

Edit a Drop-Down List based on named range of cells 3

Click on the Refers to box, and click the select button to reselect the named range of cells.

Edit a Drop-Down List based on named range of cells 4

Step 4: Reselect the named range of cells such that the modification appears in the selected range.

Edit a Drop-Down List based on named range of cells 5

Click OK.

Edit a Drop-Down List based on named range of cells 6

Click Close.

Edit a Drop-Down List based on named range of cells 6

Step 5: Now click the down arrow of you drop-down list to see that the modification appears in the drop-down list or not.

Edit a Drop-Down List based on named range of cells 8

So, this was all about the steps to edit the drops down the list. You can find more ways to do so as excel provides you with multiple methods to perform the same task.

You Might Also Like:

how-to-protect-worksheet-and-cells-in-ms_excel-2016-featured-imageHow to Protect Worksheet and Cells 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-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? Create a named range in Excel feature imageHow to Create Named Range in Excel? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? feature imageHow to COUNTIF in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016?

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 Check Hard Drive is SSD or HDD in Windows 10?
  • How to use Auto Save Session for running applications in Ubuntu 14.04
  • How to Install IIS on Windows 7
  • How to Bold, Itaticize, Strikethrough & Monospace Text in WhatsApp?
  • How to Enable Administrator Account in Windows 7?

Copyright © 2023 · QueHow · Contact Us