How do I edit an existing drop-down list in Excel?

Edit a drop-down list with items that have been entered manually

On the worksheet where you applied the drop-down list, select a cell that has the drop-down list.
Go to Data > Data Validation.
On the Settings tab, click in the Source box, and then change your list items as needed.

How do you edit links in Excel?

Edit a link

Select the cell that contains the link that you want to change. Tip: To select a hyperlink without activating the link to its destination, use the arrow keys to select the cell that contains the link.
On the Insert tab, select Hyperlink.
In the Edit Hyperlink dialog box, make the changes that you want.

Why can’t I click edit links in Excel?

The Edit Links command is unavailable if your workbook doesn’t contain links. In the Source file box, select the broken link that you want to fix. , and then click each link. Click Change Source.

How do I change the source of a link in Excel?

Changing Links

Choose Links from the Edit menu.
Select the link you want to change.
Click on Change Source.
In the Change Links To box, specify a new path for the file you want used as the source of the link.
Make any additional link changes necessary by repeating steps 2 through 4.
Click on OK.

How do you link a cell value with a an Excel drop-down list?

Creating a Dependent Drop Down List in Excel

Select the cell where you want the first (main) drop down list.
Go to Data –> Data Validation.
In the data validation dialog box, within the settings tab, select List.
In Source field, specify the range that contains the items that are to be shown in the first drop down list.

How do I break links in Excel and keep values?

The Edit Links dialog box. Select the links in the dialog box. Click Break Links and acknowledge that you really want to break the selected links. Click OK….Follow these steps:

Select the cells that contain links.
Press Ctrl+C.
Display the Paste Special dialog box.
Click the Values radio button.
Click OK.

How do I change Data Validation in Excel?

Apply data validation to cells

Select the cell(s) you want to create a rule for.
Select Data >Data Validation.
On the Settings tab, under Allow, select an option:
Under Data, select a condition.
Set the other required values based on what you chose for Allow and Data.