how to insert drop down list in google sheets

Next, select the range from, say A2:A12and then right-click > select Data Validation.Ĭheck that you have selected the correct range (1). Head back to the MainGoogle Sheet tab Give A1 the header Option 1. Click to Expand! Set up the first dropdown data validation In cell A1, add the header Option 1 and column B1 the header Option 2. Then from column A2 down type in three sets of each of the following:įinally, from B2 down type in the corresponding number followed by A, B and then C for each number set so that it looks like this. Go ahead and create a new Google Sheet tab and call it Notes. Setting up the dropdown data for Columns A & B Update column B in Maindrop-down data validation and change their relative and absolute values.Reference Column A, Mainand recreate individual selections for each row that we will hide in Notes.Set up our Column A dropdown back in Main.

Add a list of all the selected items in Column A and Column B.To achieve this dynamic dropdown in column B we need to do a number of steps: So how did we achieve this? Well, just like in the original tutorial we relied on another Google Sheet tab that, in this example, I have labelled, Notes. So our range might look like this: Click to Expand! The solution So the user can select a value in any row in column A and that will update the corresponding Google Sheets data-validation options in column B. We also want the same scenario to occur for each row. However, if the user selects ‘two’ in cell A2, then B2will have a different set of values such as: If the user selects ‘one’ in say cell A2, then cell B2will have a corresponding set of values that we will make: We’ll keep it simple and make our options: Let’s say in column A of our Google Sheet tab called Main, we want a dropdown menu for each cell in your column from, say A2:A12. Working our the remaining options for each row.Bonus 2 – Any dropdown in a row with display remaining dropdown options.Bonus 1 – A dropdown list family with options that are removed after each selection.Filtering out only those items with a corresponding selection in Col A of the adjacent row.a unique range of values for each associated cell.Creating column B options specific to each row of Column A selections.Set up the first dropdown data validation.

Setting up the dropdown data for Columns A & B.

How to insert drop down list in google sheets