How To Change Drop Down Box In Excel

Integrating Technology in the Elementary Classroom Creating A Drop

How To Change Drop Down Box In Excel. Go to the data tab on the ribbon, and then data validation. On the settings tab, click in the source box, and then change your list items as needed.

Integrating Technology in the Elementary Classroom Creating A Drop
Integrating Technology in the Elementary Classroom Creating A Drop

Go to data > data validation. Edit drop down menu based on a range of cells. On the data tab, in the data. Go to the data tab on the ribbon, and then data validation. If you can’t select data validation, the worksheet might be protected or shared. On the settings tab, click in the source box, and then change your list items as needed. In the source box, either update the cell references to include the additions. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired.

Go to data > data validation. Edit drop down menu based on a range of cells. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired. If you can’t select data validation, the worksheet might be protected or shared. On the data tab, in the data. Go to data > data validation. On the settings tab, click in the source box, and then change your list items as needed. In the source box, either update the cell references to include the additions. Go to the data tab on the ribbon, and then data validation.