Employee Handbook Add Dropdown Menu Fields For Free

Select 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.

On your Android phone or tablet, open a spreadsheet in the Google Sheets app. Tap the cell or cells where you want to create a drop-down list. In the top right, tap More . Tap Data Validation. Under "Criteria," choose an option: The cells will have a Down arrow .

Select the entire column you want to validate. Click on "Data Validation" from the Data tab. Choose "List" from the "Allow" box. Click on the arrow to the right of the "Source" box and select the cells containing the allowed values.

In a new worksheet, type the entries you want to appear in your drop-down list. Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, then Data Validation. On the Settings tab, in the Allow box, click List. Click in the Source box, then select your list range.

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.

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.

Select 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.