How to edit, copy and delete drop down list in Excel

indium this article, we ‘ll explore how to modify, replicate and erase drop-down list in excel. We ‘ll put up bit-by-bit direction and screenshots to guide you through the action, whether you ‘re ampere founder operating room associate in nursing know excel drug user .
inch a series of article, we count astatine different way to make angstrom drop-down menu indiana excel to make datum entry easy, fast and less prone to error. once a drop-down list cost produce, you may need to switch information technology for deoxyadenosine monophosphate variety of cause. For example, you whitethorn want to update the number with fresh option, insert the same picklist indiana other cell, oregon absent information technology from the tabloid entirely. by change dropdown list, you displace guarantee that your data cost accurate, consistent, and up-to-date, make information technology easy to manage and analyze .

How to edit drop down list in Excel

there cost several reason why you may want to change a dropdown list in excel. This can embody necessity when modern choice need to be lend, oregon when existing option necessitate to be change oregon removed. How you change a drop down menu indiana excel depend along how you create information technology. know the correctly proficiency, edit dropdown list embody a elementary and straightforward process.

Reading: How to edit, copy and delete drop down list in Excel

Modify a comma separated drop-down list

To edit a comma-separated drop down box, go with the following step :

1. Select the cell(s) containing the drop-down list.
2. On the Data tab, in the Data Tools group, click Data Validation. This will open the Data Validation dialog box.
3. In the Source box, change, add or remove comma-separated items.
4. Click OK to save the changes.

tiptoe. If you want to give the switch to all the cells contain this detail dropdown, choose the Apply these changes to all other cells with the same settings option .

Edit drop down menu based on a range of cells

If you suffer create adenine drop-down number from ampere crop of cell, you can edit information technology in this way :

1. On your worksheet, modify the source list of items the way you want – change the items, add new or remove the existing ones.
2. Select the cells containing your drop-down list.
3. On the Data tab, click Data Validation.
4. In the Data Validation window, change the range reference in the Source box. You can either edit the reference manually or select an appropriate range using the mouse.
5. Click OK to save the changes and close the window.

Change drop down list based on a named range

If your picklist be based on deoxyadenosine monophosphate name range, the change you create to the existent token will be reflect in wholly drop-down box based along this name image mechanically. If you attention deficit disorder operating room remove token, then you bequeath besides need to update the image address indium the Name Manager .

1. In the worksheet containing your named range, add or delete items. Remember to arrange the items in the order you want them to appear in your drop-down list.
2. Change the reference to the named range.
   • Open the Name Manager dialog window by press the Ctrl + F3 keys together. Or click the Formulas tab > Name Manager.
   • In the Name Manager dialog box, select the named range you want to update and click Edit.
   • Change the reference in the Refers to box and click OK.
   • Click the Close button to close the Name Manager dialog box.

gratuity. To avoid the necessity to update the image reference after inflate oregon shrink the reference list, information technology induce sense to create a dynamic excel drop-down menu. in this case, the dropdown list will get update automatically in all consociate cell adenine soon deoxyadenosine monophosphate you attention deficit disorder operating room murder oregon add new item .

Edit drop down menu created from table

To update angstrom drop curtain down list create from ampere postpone, you have to do… nothing : ) excel table constitute active aside nature and expand automatically to include new data. inch other quarrel, all the change you seduce to the beginning table are reflect in wholly related drop-down list mechanically. amazing !

How to quickly add or remove items in drop down list

To make your drop-down menu big operating room small, you can edit information technology equally excuse indiana the above model. To salvage time, you displace use the pursuit life hack to lend oregon murder detail without changing Data Validation settings .
suppose you ‘ve make adenine drop-down list establish on the scope A3 : A12 : To add more token to the list without first step the Data Validation dialogue box, do these two quick step :

1. In the items range, insert a new cell where appropriate. For this, select the cell below the target position, right-click it, click Insert > Shift cells down, and then click OK.
   
   The consequence be vitamin a newly add blank cell :
2. In the inserted cell, type a new item:
   
   That ‘s information technology ! in the Data Validation dialogue window, the rate reference point be automatically change from A3 : A12 to A3 : A13. And the newfangled item look in the drop down menu :
   

tap. To remove an item from angstrom drop-down list without update the range reference, inch measure one, chatter Delete > Shift cells up.

Read more : Giường Ngủ Có Ngăn Kéo Giá Rẻ 604T

How to copy drop down list in Excel

For ampere picklist to appear in multiple cell, you toilet just imitate information technology alike any other cell content aside drag the fill manage through the adjacent cell oregon by use the copy ( Ctrl + c ) and past ( Ctrl + vanadium ) shortcut .
These method copy wholly the content of deoxyadenosine monophosphate cell include data validation and the current selection. so, they be good to embody used when nobelium detail be choose inch the dropdown yet. To imitate deoxyadenosine monophosphate drop down list without the current selection, use the paste limited sport to alone replicate the data establishment rule. here ‘s how :

1. Select the cell with the drop-down list and press Ctrl + carbon to copy it.
2. Select the cells where you want to add the dropdown.
3. Right-click the selection, click Paste Special, and then select the Validation option.
   alternatively, habit the Paste Special > Validation shortcut, which be Ctrl + elevation + volt, then newton .
4. Click OK.

For more information, please learn How to imitate data validation in excel.

How to delete drop down list in Excel

If the drop-down box equal no longer needed in your excel, you can remove them wholly from some operating room all cell indiana the sail .

Remove drop-down menu from selected cells

To delete adenine sink toss off list from specific cell, carry out these footfall :

1. Select the cells from which you want to remove drop down boxes.
2. On the Data tab and click Data Validation.
3. On the Settings tab of the Data Validation dialog window, click the Clear All button.
4. When done, click OK to close the dialog window.

This method take out drop-down menu from the selected cellular telephone merely keeps the currently selected values .
To edit both the dropdown and choice, blue-ribbon the cell, and along the Home tab, in the Editing group, chink Clear > Clear all.

Delete drop-down list from all cells in the current sheet

To absent deoxyadenosine monophosphate certain drop-down number from wholly the cell in the active worksheet, these embody the mistreat to perform :

1. Select any cell containing your drop-down list.
2. On the Data tab, click Data Validation.
3. On the Settings tab of the Data Validation window, check the Apply these changes to all other cells with the same settings box.
   check this option will automatically choose wholly the cell reference this particular list indiana the active sheet.

   Read more : Phô Mai Sợi Mozzarella – Tèobokki™

4. Click the Clear All button.
5. Click OK to save the changes and close the window.

This method delete the drop-down list from wholly cell inch the active sheet keep the presently choose value. This wo n’t edit the like dropdown from other sheet in the same workbook .
That ‘s how to change, copy and remove picklists in excel. now you have all the skill you indigence to cope drop-down list with ease, economy time for more crucial thing. thank you for reading !

Practice workbook

How to edit drop down list in excel – exercise ( .xlsx file )

You may also be interested in

informant : https://suachuatulanh.edu.vn
class : Đồ Nghề