Waiver Insert Dropdown List For Free

Create a drop-down listSelect the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

In the same or in another spreadsheet, select a cell or several cells in which you want your primary drop-down list to appear. Go to the Data tab, click Data Validation and set up a drop-down list based on a named range in the usual way by selecting List under Allow and entering the range name in the Source box.

Creating a Dependent Drop Down List in ExcelSelect 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.More items...

Edit a drop-down list with items that have been entered manuallyOn 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.More items...

Creating a Dependent Drop Down List in ExcelSelect 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.More items...

Instead of limiting the drop down list to a single selection, you can use a bit of programming, combined with the data validation list, and allow multiple selections. With a few adjustments to the VBA code, you can display all the selected items across a row, or down a column, or keep them in a single cell.

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. Each item should be separated by a comma, with no spaces in between like this: Yes,No,Maybe.