how to insert a drop down list in google sheets

Your range address with absolute references will look like this:Ĭlick the Select a data range icon. Google Sheets recommends using absolute references when entering your cell or range address to lock your selected rows and columns. Then select the Dropdown (from a range) option.Įnter the cell or range address where you want to base your drop-down list (A3:A7). Then click on Data validation.Ĭlick on the Add rule button in the Data validation rules side pane.Įnsure you have the correct sheet and range of cells in the Apply to range field. Now that we have our sample dataset, let’s create a drop-down list to enter data for the Deal stage column (column B).įirst, select the cell range under column B (B3:B18) and click the Data tab on the top menu.

Read this blog post on how to connect HubSpot to Google Sheets for a full walkthrough of the process. Let’s use a dataset imported from HubSpot to Google Sheets via Coefficient.Ĭoefficient is Google Sheets add-on that allows you to pull data from your business systems, such as Salesforce, Looker, HubSpot, and more, into your spreadsheet. To do this, we’ll need sample data to work with. Google Sheets lets you create a drop-down list using an existing dataset in a cell range. Method 1: Create a Drop-Down List from a Range of Cells The methods below outline how to add a drop-down list in Google Sheets. Three Ways to Make a Drop-Down List in Google Sheets This is the ultimate guide to drop-down lists in Google Sheets, based on real examples and step-by-step walkthroughs. They can also make your data more dynamic in Google Sheets. You can use drop-down lists to avoid typos, misspellings, or other errors.

They make data entry in Google Sheets more accurate and consistent. The following guide will show you how to add a drop-down list in Google Sheets with ease.ĭrop-down lists simplify and streamline repetitive data entry tasks.

How to insert a drop down list in google sheets