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 data and to make selections easier. You can add a drop down…

Adding a drop down list in Google Sheets is a great way to keep track of data and to make selections easier. You can add a drop down list in a cell by selecting the cell and then going to the "Data" tab and selecting "Validation." From there, you can choose "List." This will give you a box in which you can type the items that you want to appear in the drop down list. You can also choose the "Source" tab and select "Sheet Name" to have the items in the drop down list come from a different sheet in your Google Sheets document.

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 data and to make selections easier. You can add a drop down list in a cell by selecting the cell and then going to the "Data" tab and selecting "Validation." From there, you can choose "List." This will give you a box in which you can type the items that you want to appear in the drop down list. You can also choose the "Source" tab and select "Sheet Name" to have the items in the drop down list come from a different sheet in your Google Sheets document.

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