IOU Add Dropdown List For Free

Right-click one of the cells you highlighted and click "Paste special." The Paste Special dialog box opens and displays several pasting options. Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.

No, but the best way to do this would be to insert a drop down box form control, then assign the value to a cell. Then change your IF function to reference that cell, effectively making the IF function dynamic.

Create the Drop Down ListSelect the cell(s) where you want the drop down list of customers.On the Ribbon, click the Data tab, then click Data Validation.In the Data Validation dialog box, under Allow, select List.In the Source box, type an IF formula that refers to the active cell, and the named lists.More items...?Nov 24, 2021

Copy drop-down list from one cell to anotherCopy the cell by pressing Ctrl + C or Right-click -> Copy.Select the cells where you want to paste the drop down list.Right-click, select paste special, click on Validation and press OK"Nov 22, 2016

Custom Data ValidationStep 1: Select the range of cells you want validated.Step 2: Go to the Data tab of the ribbon > Data Validation > Data Validation.Step 3: In the Settings tab choose 'Custom' from the 'Allow' list:Step 4: Enter your formula.More items...?Sep 15, 2014

Steps in Using Conditional Data ValidationOn the second sheet, create the named ranges shown in the table below.On the first sheet, select cell B1.On the Data tab, in the Data Tools group, click Data Validation.In the Allow box, click List.Click in the Source box and type =Main.Click OK.More items...

Here's how:Select one or more cells to validate.Open the Data Validation dialog box.On the Settings tab of the Data Validation dialog window, select Custom in the Allow box, and enter your data validation formula in the Formula box.Click OK.Aug 17, 2017