Skip to content
SayScreen

Google Sheets tutorial

How to create a dropdown list from another tab in Google Sheets

SayScreen

This whole video was made by AI.

Make your own at sayscreen.com

Start for $1

$1 for 7 days, then $49/month

  • 4:02 video
  • 10 steps
  • Last verified November 6, 2026

Keep dropdown options in one place instead of typing them into each validation rule. This tutorial builds a Tasks tab and a Lists tab, then links the task-status cells to Lists!A2:A. That open-ended range starts below the Status header and includes new choices added further down column A. You will choose statuses for three sample tasks, reject invalid entries, and add Blocked to the source list without rebuilding the dropdown. Both tabs are in the same spreadsheet; no script or add-on is needed.

Steps

  1. 1Create the Tasks and Lists tabsOpen a blank spreadsheet at sheets.new. Double-click Sheet1 and rename it Tasks. Click the plus button to add another tab, then rename it Lists.0:10
  2. 2Enter the status options on ListsOn Lists, enter Status in A1, Not started in A2, In progress in A3 and Done in A4. Keep the header above the source range so it is not offered as a status.0:32
  3. 3Build the task tableSwitch to Tasks. Enter Task in A1 and Status in B1. Put Order supplies, Send invoice and Review draft in A2:A4; leave B2:B4 ready for the dropdowns.0:40
  4. 4Select B2:B4 and add a data validation ruleSelect the three status cells on Tasks. Choose Data > Data validation, then click Add rule in the right-hand panel. Confirm the rule applies to Tasks!B2:B4.0:58
  5. 5Choose Dropdown (from a range) and enter Lists!A2:AChange Criteria to Dropdown (from a range). Enter Lists!A2:A as the source. The exclamation mark separates the tab name from its cells. With no ending row number, the range includes column A from row 2 downward, including future additions.1:29
  6. 6Reject invalid input and saveExpand Advanced options and scroll to If the data is invalid. Select Reject the input, click Done and close the panel. The rule is configured to reject values outside the source list; the tutorial does not demonstrate typing an invalid value.2:05
  7. 7Choose a status for each taskUse the dropdown in B2 to mark Order supplies as Done, B3 to mark Send invoice as In progress, and B4 to mark Review draft as Not started. Each cell uses the same source list.2:30
  8. 8Fit the status column to its contentsDouble-click the right edge of column B so the status labels have room to display.3:01
  9. 9Add Blocked in Lists!A5Return to Lists and enter Blocked in A5, directly below Done. The narration says "5th column" at this point; the intended cell is A5, row 5 of column A, as specified in the project instructions. Leave the validation rule unchanged.3:07
  10. 10Check the new option back on TasksReturn to Tasks and open the Send invoice dropdown in B3. Blocked is now available because A5 is inside Lists!A2:A. Choose it to update the task status. The source range grows with new choices; the target dropdown range remains B2:B4, so extend the validation rule separately when adding more task rows.3:17

Transcript

0:00In this video, you'll build a status dropdown in Google Sheets whose options live on a separate tab, so the list grows automatically whenever you add a new choice.

0:10First, set up the two tabs. Double-click Sheet1 to rename it.

0:15Call it Tasks. This is where the dropdowns will go.

0:19Next, click the plus button to add a second tab for the option list.

0:24Double-click the new tab to give it a name too.

0:27Name it Lists. It will hold the choices the dropdown offers.

0:32In column A, type a Status header, then the three options: Not started, In progress, and Done.

0:40Switch back to the Tasks tab to lay out the task list.

0:44In column A, add a Task header and three tasks: Order supplies, Send invoice, and Review draft.

0:53Then label column B Status. That's where the dropdowns will live.

0:58Select the three status cells, B2 through B4, so the dropdown applies to every task.

1:05Open the Data menu, where Sheets keeps its validation tools.

1:09Choose Data validation.

1:12A rules panel opens on the right. Click Add rule. The range is already filled in as Tasks B2 to B4. By default, Sheets offers a dropdown with options typed right here, but we want them to come from the Lists tab instead.

1:29Open the Criteria menu to change the dropdown type.

1:33Pick Dropdown, from a range.

1:36For the source, type Lists, exclamation mark, A2 colon A. That means column A of the Lists tab, from row 2 all the way down. Notice there's no ending row number. Because the range is open-ended, any option you add further down column A later will be picked up automatically. Sheets immediately reads the source and previews the three options from the Lists tab: Not started, In progress, and Done.

2:05Expand Advanced options to decide what happens when someone types something that isn't on the list.

2:11Scroll down to see the new settings.

2:14Under If the data is invalid, make sure Reject the input is selected. Now typos or made-up statuses simply won't be accepted.

2:23Click Done to save the rule.

2:26The rule is saved, so close the panel.

2:30Each status cell now has a dropdown chip. Open the one for Order supplies.

2:37The three options from the Lists tab appear. The supplies are ordered, so pick Done.

2:43Next, open the dropdown for Send invoice.

2:48Mark this one In progress.

2:51And open the last one, for Review draft.

2:56The draft hasn't been touched yet, so choose Not started.

3:01The labels are a bit cramped, so double-click the edge of column B to fit it to its contents.

3:07Now say your team needs a new status. Head over to the Lists tab.

3:12In the 5th column right under Done, type Blocked.

3:17That's it. No need to touch the validation rule. Go back to Tasks.

3:23Open the dropdown for Send invoice. Blocked is already in the list. Because the source range is Lists A2 to A with no end row, it covers the whole column, so every new entry you add below becomes an option automatically.

3:39The invoice is waiting on someone else, so choose Blocked. And there's the finished task list, with every status chosen from options that live on the Lists tab. You've built a dropdown that pulls its options from another tab, set it to reject anything that isn't on the list, and used an open-ended range so new options show up on their own.

Google Sheets is a trademark of its owner. SayScreen isn't affiliated with, sponsored or endorsed by Google Sheets; this video shows the public app as it looked when it was recorded, and we last checked the steps on November 6, 2026. If Google Sheets has changed since, tell us at hey@sayscreen.com.

All Google Sheets videos