How to Add a Drop down List in Google Sheets

Adding a drop down list in Google Sheets is a great way to keep track of specific information or to limit the options that are…

Adding a drop down list in Google Sheets is a great way to keep track of specific information or to limit the options that are available to a user. To add a drop down list in Google Sheets, first open a new spreadsheet or select an existing spreadsheet. Next, select the cell or cells in which you would like to add the drop down list. Then, click on the "Data" tab and select "Validation." In the "Validation" window, select "List." In the "Source" field, enter the list of options that you would like to appear in the drop down list. You can also specify the order of the options by entering them in the "List order" field. You can also specify whether users can enter their own values or not by selecting the "Allow user entry" check box. Click "OK" to save your changes.

PERSONAL FINANCE
Buy vs Rent
Should you buy a house or rent?
Startur
B2B SaaS Revenue
Forecast your inbound and outbound leads to determine revenue, and understand what kind of sales funnel you need to hit your revenue targets.
FINANCE
Detailed Headcount Model
Understand the breakdown of your headcount and payroll costs by Department (Sales, Engineering, etc.) and plan your future hires.
Google Sheets

How to Add a Drop down List in Google Sheets

How to Add a Drop down List in Google Sheets

Adding a drop down list in Google Sheets is a great way to keep track of specific information or to limit the options that are available to a user. To add a drop down list in Google Sheets, first open a new spreadsheet or select an existing spreadsheet. Next, select the cell or cells in which you would like to add the drop down list. Then, click on the "Data" tab and select "Validation." In the "Validation" window, select "List." In the "Source" field, enter the list of options that you would like to appear in the drop down list. You can also specify the order of the options by entering them in the "List order" field. You can also specify whether users can enter their own values or not by selecting the "Allow user entry" check box. Click "OK" to save your changes.

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