How to Edit a Drop Down List in Excel | 4 Methods in 2023

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

Every one of you uses Microsoft Excel for a different type of work. Well, it is understandable you can commit mistakes while preparing a drop-down list in Excel. To rectify all the errors in Microsoft Excel, you need to know about some amazing methods that will help you know how to edit a drop down list in Excel. You might think it is a tedious job, but it is very easy to implement.

Drop drown list is an important function of Microsoft Excel. It is helpful to create forms and deliver policies for others. If the drop-down list is in the Excel table, adding or deleting the items is easy. Simply you have to add or delete the items in a table, and Microsoft Excel will update the list automatically. However, if your drop-down list is in a different format, you need to know about the other important tools.

If you want to know more about how to edit a drop down list in Microsoft Excel, follow the steps in the below subheadings. This will help you easily modify the items on your excel sheet and get it done at the right time.

How to Edit a Drop Down List in Excel?

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

To edit a drop-down list in Microsoft Excel is super easy. Whether you want to edit an excel table, cell range named range, or the manual entries. There are many functions in Microsoft Excel, and you must know about them to get your work done instantly.

So, let’s get started with how to edit a drop down list in Microsoft Excel.

How to Edit a Drop Down List in Microsoft Excel | From Table

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

If you have prepared the list of items in a table format, you must know how to edit a drop down list in Microsoft Excel. It is super easy to use and you can get instant results. Follow the steps to know more about it.

  1. On your worksheet, open the names of the list.
  2. Move to the last row.
  3. Press the Enter key.
  4. Add a new item if you want.

Thus, the new item will be added to the selection list. If you want to delete an item from a list, follow the few steps-

  1. Right-click on the item.
  2. Tap on Delete.
  3. Tap on Table Rows.

Once you remove the item from a list, it will create a space in the list. To fill up the space, you can move the rest of the items to the top.

How to Edit a Drop Down List in Microsoft Excel | From a Cell Range

  1. Open the excel sheet with a drop-down list.
  2. Add or delete the items from a list.
  3. Tap on the Cell that contains a drop-down list.
  4. Click on Data Validation which is on the right side of the screen.
How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

5. In the drop-down menu, select Data validation.

6. Once the Data Validation page opens, tap on Settings.

7. Tap on Source.

8. Modify the Cell range (include or delete the items).

9. Tap on Ok.

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

Note:- Make sure to modify the data range.

How to Edit a Drop Down List in Microsoft Excel | From a Name Range

  1. Open the excel sheet with a drop-down list.
  2. Add or delete the items from a list.
  3. Under the Formulas icon, Tap on Name Range.
  4. Choose the drop-down list of Named Range.
  5. Under References, add or delete the items.
How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

6. Tap on Close.

7. Finally, tap on Save.

8. Under Refers to, do the changes in name range.

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

How to Edit a Drop Down List in Microsoft Excel | From Manually Entered Data

  1. On a worksheet, go to the Data option.
  2. Tap on Data Validation.
How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

3. On the Data Validation page, tap on the Source option.

4. Separate all the items with a comma.

5. Tap on Ok.

How to Edit a Drop Down List in Microsoft Excel | 4 Methods in 2022

How to Edit a Drop Down List in Microsoft Excel?

If you are finding the crystal and clear answers on how to edit a drop-down list in Microsoft Excel, follow the step by step guide in the below video-

How to Edit a Drop-Down List in Excel

Wrapping Up

I hope this article will help you in preparing your data on an Excel sheet. You can edit easily with the help of the above methods. This was all about how to edit a drop-down list in Microsoft Excel. Feel free to share the article with your friends. Keep visiting Path of EX for all the exciting stuff. Stay tuned!

Frequently Asked Questions

How to delete a drop down list?

To remove a drop-down list, tap on Data, tap on Data Validation, tap on Settings, tap on Clear All and finally tap on Ok.

How to add color to the drop down list in Excel?

Tap on Conditional Formatting, and tap on New Rule. On the next page, tap on Format only cells that contain, select Specific Text, choose containing and tap on the icon that has a red arrow in it. Once done, tap on the Format icon, choose the color, and tap on Ok.

Why can’t I find a drop down list in Excel?

If you can’t find a drop down list in Excel, make sure you have selected the data in the cell.  You can also check the settings in Excel. Simply tap on the Excel option>Advanced>For objects, show>Ok.

Leave a Comment

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