# How to Create a Drop-Down List in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Create a Drop-Down List in Google Sheets
   - body: This guide provides a detailed walkthrough on how to create a drop-down list in Google Sheets. Follow each step closely to successfully set up your drop-down list.
   - voiceover: This guide provides a detailed walkthrough on how to create a drop-down list in Google Sheets. Follow the steps below to add a drop-down list to your spreadsheet, customize its appearance, and set criteria according to your needs.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff9013000m0cjp3o7egk2y.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the range where you want to make the dropdown
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (704, 813), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (704, 813), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Select the range where you want to make the dropdown.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff93ye000o0cjp5gs2cg9g.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2b980008033pr8414xgo.png
2. step_02 [image] - Click on the Insert option
   - source type: IMAGE
   - description: Select the Cell
   - target: (189.00001888699003, 75.30239484133119), rect: top=34 left=182.3125 width=54.520835876464844 height=24
   - hotspots: 1
     - hotspot_01 (189.00001888699003, 75.30239484133119), rect: top=34 left=182.3125 width=54.520835876464844 height=24
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the 'Insert' option in the menu bar at the top of the screen.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff93yx000p0cjp3haqdatq.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2dy4000a033pixhalzul.png
3. step_03 [image] - From the dropdown menu, choose 'Dropdowm'
   - source type: IMAGE
   - description: Access Data Validation
   - target: (323.5131078670802, 549.1818589731179), rect: top=550.6666870117188 left=183.64584350585938 width=320 height=32
   - hotspots: 1
     - hotspot_01 (323.5131078670802, 549.1818589731179), rect: top=550.6666870117188 left=183.64584350585938 width=320 height=32
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: From the dropdown menu that appears, choose 'Dropdown'.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff93zg000q0cjpdp2x80cd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2g8t000b033pucesqgn7.png
4. step_04 [image] - Change the color and titles if you want
   - source type: IMAGE
   - description: Choose Criteria
   - target: (2198.910848906639, 305.96985113048646), rect: top=308.66668701171875 left=2254 width=54.66666793823242 height=36.66666793823242
   - hotspots: 1
     - hotspot_01 (2198.910848906639, 305.96985113048646), rect: top=308.66668701171875 left=2254 width=54.66666793823242 height=36.66666793823242
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Change the titles and colors of the options if you wish.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff9400000r0cjperx12a20.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2iuw000c033phq3lawst.png
5. step_05 [image] - Choose the colors
   - source type: IMAGE
   - target: (2552.243426122411, 422.3647086272634), rect: top=344.3647086272634 left=2265.5767594557447 width=286.6666666666667 height=156
   - hotspots: 1
     - hotspot_01 (2552.243426122411, 422.3647086272634), rect: top=344.3647086272634 left=2265.5767594557447 width=286.6666666666667 height=156 style=STYLE2
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Choose the colors for each option in the dropdown list.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff940k000s0cjp01ci8hg4.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2jjr000d033pqnnxglmu.png
6. step_06 [image] - Choose criteria
   - source type: IMAGE
   - description: Save Settings
   - target: (2200.3361307703385, 245.09154464740826), rect: top=256 left=2249.33349609375 width=232.5416717529297 height=20
   - hotspots: 1
     - hotspot_01 (2200.3361307703385, 245.09154464740826), rect: top=256 left=2249.33349609375 width=232.5416717529297 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Choose the criteria for the dropdown list.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff9413000t0cjphc2q32so.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2k86000e033pil3k6mno.png
7. step_07 [image] - Choose criteria according to your need
   - source type: IMAGE
   - description: Validate Drop-Down List
   - target: (2209.972320938866, 264.3638565064115), rect: top=256.3333435058594 left=2279.33349609375 width=160.8125 height=20
   - hotspots: 1
     - hotspot_01 (2209.972320938866, 264.3638565064115), rect: top=256.3333435058594 left=2279.33349609375 width=160.8125 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Set the criteria according to your specific needs.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff941m000u0cjphm4u1aiy.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2lg9000f033pnxv1ciax.png
8. step_08 [image] - Save the changes once done.
   - source type: IMAGE
   - description: Adjust as Needed
   - target: (2324.548243427509, 1156.0915868459604), rect: top=1178.3333740234375 left=2421.916748046875 width=86.08333587646484 height=36
   - hotspots: 1
     - hotspot_01 (2324.548243427509, 1156.0915868459604), rect: top=1178.3333740234375 left=2421.916748046875 width=86.08333587646484 height=36
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Save the changes once you have configured the dropdown list.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff9426000v0cjp5tpf4ijx.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff2p8c000g033p8a4xsyie.png
10. [Outro] Congratulations!
   - body: You have successfully created a drop-down list in Google Sheets. You can now use this feature to make data entry more efficient and error-free. For further customization and advanced features, explore additional data validation options in Google Sheets.
   - voiceover: After you've created your drop-down list, you may want to test it by selecting different options. If necessary, return to the dropdown settings to make any adjustments or add more options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6ff1za10001ju0dkskk1dls/cm6ff921v000n0cjp49vobgk5.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6ff1za10001ju0dkskk1dls/tour