How to Pick a Value from Drop-Down List

You can change a cell value to any of existing records using the drop-down list, please see below for details:

Step 1: Right-click any of the cells that you want to change;

Step 2: Select "Pick from Drop-down List" from the dialog box;

Step 3: Select the value you want to change to from the list;

Step 4: The cell value will change with the selected value.