How to Create Dynamic Drop-Down List in Google Sheets (Khmer)

Hello everyone! Today I show you how to create Static and Dynamic dropdown lists in Google Sheets step by step with easy video guide in Khmer language.

Dropdown lists help prevent typing mistakes and speed up data entry. A Dynamic Dropdown is super powerful because it updates options automatically whenever you add new items to your source list!

Method 1: Create Static Drop-Down List

Use static dropdown when you have fixed options that never change (e.g. Pending, In Progress, Done).

Step by Step:

1. Select target cells (e.g. B2:B10).
2. Click Insert menu on top ➔ select Dropdown (or right-click ➔ Dropdown).
3. In Data validation rules panel on right:
   • Under Criteria, keep Dropdown.
   • Type your options manually: Option 1, Option 2, Option 3.
   • Pick background colors for each chip.
4. Click Done.

Method 2: Create Dynamic Drop-Down List (From Range)

Use dynamic dropdown when options change often or new items get added to master list in another tab.

Step by Step:

1. Select target cells where you want dropdown.
2. Click Insert ➔ select Dropdown.
3. Under Criteria dropdown, select Dropdown (from a range).
4. Click grid icon to choose range ➔ enter range with open end row:

   Sheet2!A2:A
   

   (Leaving end row open A2:A means any new item typed at bottom of Column A will auto show in dropdown!)
5. Click OK ➔ click Done.

Method 3: Clean Dynamic Dropdown with UNIQUE + SORT Formula

If your master list has duplicates or messy blank rows, clean it first using formula:

In helper column (e.g. Sheet2!C2), type:

=SORT(UNIQUE(FILTER(A2:A, A2:A <> "")))

• FILTER(A2:A, A2:A <> ""): Removes empty blank rows.
• UNIQUE(...): Removes duplicate items.
• SORT(...): Sorts items alphabetically A-Z.

Now set your Dropdown from a range to Sheet2!C2:C!

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to create static and dynamic dropdown list in Google Sheets:

💡 Quick Tip:

• Open-Ended Range Trick (A2:A): Always leave end row number blank when selecting range (Sheet2!A2:A instead of A2:A10). That way, new items added in future show in dropdown automatically without changing settings!
• Change Chip to Classic Arrow: Google Sheets displays dropdown as colorful "Chips" by default. Click Advanced options at bottom of panel ➔ change Display style to Arrow for classic dropdown look!
• Copy Dropdown to Other Cells: Copy cell ➔ select target range ➔ right-click ➔ Paste special ➔ Paste data validation only.

📚 Related Resources

• How to Highlight Rows Automatically Based on Checkbox in Google Sheets
• How to Split Text in Google Sheets (3 Easy Methods)
• How to Clean Extra Spaces in Google Sheets (4 Easy Methods)
• Top 15 Basic Excel Formulas Every Beginner Should Know