How do I add something to a drop down list in Excel?

How do I add something to a drop down list in Excel?

Create a drop-down list

1. Select the cells that you want to contain the lists.
2. On the ribbon, click DATA > Data Validation.
3. In the dialog, set Allow to List.
4. 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.

How do I edit a drop down list in sheets?

Change or delete a drop-down list

1. Open a spreadsheet in Google Sheets.
2. Select the cell or cells you’d like to change.
3. Click Data. Data validation.
4. To change the options listed, edit the items next to “Criteria.”
5. To delete a list, click Remove validation.
6. Click Save.

How do you edit a locked drop down list in Excel?

Click HOME, then click the Format Cell dialog box launcher (the arrow to the right of Alignment in the ribbon). Click the Protection tab, check the Locked box, and click OK.

How do I add data validation list in Excel?

Add data validation to a cell or a range

1. Select one or more cells to validate.
2. On the Data tab, in the Data Tools group, click Data Validation.
3. On the Settings tab, in the Allow box, select List.
4. In the Source box, type your list values, separated by commas.
5. Make sure that the In-cell dropdown check box is selected.

How do I change data validation in Excel?

Select a cell or cells that reference your Excel Data Validation list, i.e. cells containing a drop-down box that you want to edit. Click Data Validation (Excel ribbon > Data tab). Delete or type new items in the Source box. Click OK to save the changes and close the Excel Data Validation window.

How do you use data validation in Excel?

How do I unlock data validation in Excel 2010?

Select the cell(s) with data validation. On the Data tab, click the Data Validation button. On the Settings tab, click the Clear All button, and then click OK.

How do I remove a drop down list in Excel Windows 10?

1. Select the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.
2. Click Data >Data Validation.
3. On the Settings tab, click Clear All.
4. Click OK.

How do I insert a list box in Excel 2010?

Add a list box to a worksheet

1. Create a list of items that you want to displayed in your list box like in this picture.
2. Click Developer > Insert.
3. Under Form Controls, click List box (Form Control).
4. Click the cell where you want to create the list box.
5. Click Properties > Control and set the required properties:

How do I get rid of a drop down box in Excel?

Remove a drop-down list

1. Select the cell with the drop-down list. If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.
2. Click Data >Data Validation.
3. On the Settings tab, click Clear All.
4. Click OK.