How to Edit a Dropdown List in Microsoft Excel

In this article, we are going to learn how to edit Excel drop down list if we have already drop down list. 

Let us take an example:

We have dropdown list in a sheet, and in which cell we have dropdown list, we want to change the list of the cells.

For Example:- In cell F6, we have dropdown list to main category of Week names, Month names and Serial Number and cell G6 contains the sub category to each main category. Now we want to change the main category in Fruit names and Vegetable names.

To edit the dropdown list, follow the below given steps:-
img1

 

  • Select the cell F6.
  • Go to Data tab > Data Tools > Data Validation.

img2

 

  • Or use ALT + D + L shortcut keys for Data Validation
  • In Settings group > Allow > List > Source.
  • Change the old source with the new source name, and click on OK.

img3
 

  • Select the cell G6.
  • Again open the Data Validation dialog box.
  • Click on OK.

img4

 

When we will select the fruit name from the list in cell G6, we will have only fruits name as well with Vegetable names.

This is the way we can edit in the dropdown list and change the list selection.

 


image 48

Below you can find more example:-

How to create drop down list?

How to delete drop down list?

How to apply Conditional Formatting in drop down list?

How to create dependent drop down list?

How to create multiple dropdown List without repetition using named ranges?

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 

 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube