Edit Dropdown Release For Free

When the drop down list appears, click the down arrow (or up arrow) key on your keyboard, to move to the name that you want to delete. On the keyboard, click the Delete key.

Hover over the saved entry in the dropdown to highlight it. On your keyboard, press Shift and then Delete.

How to Edit a Drop-Down List in Excel - YouTube YouTube Start of suggested clip End of suggested clip The list of three summer months will do for this question. What we need to do is edit the listMoreThe list of three summer months will do for this question. What we need to do is edit the list according to this click on the cell that contains the drop-down list you want to edit. It's the cell with

Select the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them. Click Data >Data Validation. On the Settings tab, click Clear All. Click OK.

Select a cell or cells that reference your Excel Data Validation list, i.e. cells containing a drop-down box that you want to edit. Click Data Validation (Excel ribbon > Data tab). Delete or type new items in the Source box. Click OK to save the changes and close the Excel Data Validation window.

Edit a drop-down list that's based on an Excel Table To add an item, go to the end of the list and type the new item. To remove an item, press Delete. Tip: If the item you want to delete is somewhere in the middle of your list, right-click its cell, click Delete, and then click OK to shift the cells up.

Editing a drop-down menu based on a range of cells Select the cell or cells containing your drop-down list. Click Data Validation on the Data tab. In the Excel Data Validation window, on the Settings tab, change the cell references in the Source box. You can either edit them manually or click the Collapse Dialog icon.