0
0
Google Sheetsspreadsheet~10 mins

Dropdown menus in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

A list of fruits in column A and a dropdown menu in cell B2 to select one fruit.

CellValue
A1Fruit
A2Apple
A3Banana
A4Cherry
B1Select your favorite fruit:
B2
Formula Trace
=A2:A4
Step 1: A2:A4
Cell Reference Map
Dropdown
↓
Dropdown
Cell B2 has a dropdown menu that uses the list of fruits from cells A2 to A4 as options.
Result
   A       B
1  Fruit   Select your favorite fruit:
2  Apple   Banana
3  Banana
4  Cherry
Cell B2 shows the selected fruit from the dropdown menu. Here, Banana is selected.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the dropdown menu in cell B2 show?
AApple, Banana, Cherry
BOnly Apple
CNumbers 1 to 3
DEmpty list
Key Result
Dropdown menus use a range of cells as the source list for options.