Google Sheets

How to Make a Drop Down List in Google Sheets

How to Make a Drop Down List in Google Sheets

To make a drop-down list in Google Sheets, you first need to create a list of items that you want to appear in the drop-down menu. Then, you need to create a column in your spreadsheet where you will enter the data for the drop-down list. In the cell where you want the drop-down list to appear, select "Data" from the menu bar, then "Validation." From the "Validation" menu, select "List." In the "Source" field, enter the range of cells that contain the list of items you want to appear in the drop-down menu. Click "OK."

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.