Invoice Template Add Dropdown List For Free

Select the cells that have the drop-down list. Go to Data > Data Validation. On the Settings tab, click in the Source box. Then do one of the following: If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need.

Select the cells where you want the Client drop down lists. On the Ribbon, click the Data tab, then click Data Validation (In Excel 2003, click the Data menu, then click Validation.) From the Allow drop-down list, choose List. In the Source box, type an equal sign and the list name, for example: =ClientList.

Select the cells where you want the drop down lists. Choose Data>Validation. In the Allow box, choose List. In the Source box, type the list name, preceded by an equal sign, e.g.: =MyList. Click OK.

Select the cell or range of cells where you want the drop-down list to appear (C2 in this example). Go to Data > Data Tools > Data Validation. In the Data Validation dialogue box, within the settings tab, select 'List' as Validation Criteria.

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. Click OK.

In the Data Validation dialog box, uncheck the Show error alert after invalid data is entered box under Error Alert tab, then click the OK button. Then you can enter any text into drop down list cells as you need without getting an error alert.

Can you create a Data Validation Dropdown list that uses data from another workbook as a source? The answer is Yes you can! Here's how. First you open a workbook where the source cells for your dropdown reside.