Google Sheets: Create Dropdown

Aug 13, 2019
  • Select a cell
  • Menu: Data -> Data Validation
  • For Criteria, select List of items. Enter items separated by command: Pending,Approved,Rejected).
  • Click Save.

References:

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.

Tags
Related articles
Google Sheets App Scripts: Make PubSub Publish CallSetup and Access Google Sheets API With PythonAnalyze Historical Stock Price With Google Sheets: GOOGLEFINANCE ExampleAndroid (Java/Kotlin) Google Sheets API: Metadata (Hide note/string in Sheet)Setup Google Sheets API for Android (Java/Kotlin)Google Sheets: Import Yahoo Finance Key Statistics Like PE ratioGoogle Sheets: Show Elapsed TimePython Google Sheets API: Hide or Show SheetGoogle Sheets: Convert Unix Epoch Timestamp to DateGoogle Sheets App Scripts: Show and Close SidebarGoogle Sheets App Scripts: Show AlertGoogle Sheets Add Button With Apps Script EventPython Google Sheets API: Duplicate SheetPython Google Sheets API: Get Sheet Id by Sheet NameGoogle Sheets Apps Scripts: Custom Function Convert Unix Timestamp to DatePython Google Sheets API: Read All RowsPython Google Sheets API: Update Cell DataPython Google Sheets API: Append New RowGoogle Sheets Lock/Freeze Part of Cell Formula Reference When Copy Cells or Rows