2 Quick Ways to Remove Blank Cells from Your List in Google Sheets (Khmer)

Hello everyone! Today I show you 2 quick ways to remove blank cells and empty rows from your list in Google Sheets step by step with easy video guide in Khmer language.

Blank cells inside data list make your reports look messy and break formulas. Here are 2 fast solutions to clean them instantly!

Method 1: Use FILTER Formula (Dynamic List)

If you want a clean new list that automatically updates when you add or remove items:

Use FILTER() function:

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

• A2:A: Your list column range.
• <> "": Means "is not empty".
• Result: Instantly creates a clean list with 0 blank cells!

For Multi-Column Table:

=FILTER(A2:C, A2:A <> "")

• Removes rows where Column A is empty across Columns A, B, and C.

Method 2: Use Built-in Filter Tool (No Formula)

If you want to filter out blank cells directly inside your existing table without writing formulas:

Step by Step:

1. Select your table columns (e.g. A1:C100).
2. Click Data menu ➔ select Create a filter (or click Filter icon on toolbar).
3. Click green filter funnel icon on top of column header.
4. Uncheck (Blanks) box at bottom of list.
5. Click OK.

All empty blank rows will hide instantly!

Method 3: Use QUERY Formula (Advanced Option)

If you love SQL queries in Google Sheets, use QUERY():

=QUERY(A2:A, "SELECT A WHERE A IS NOT NULL", 0)

• WHERE A IS NOT NULL: Tells Google Sheets to ignore all blank cells.

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to remove blank cells in Google Sheets:

💡 Quick Tip:

• Sort A-Z Push Blanks to Bottom: Quickest manual trick! Select column ➔ click Data ➔ Sort range by Column A (A to Z). Google Sheets will automatically push all empty blank cells to the very bottom!
• Remove Blanks + Remove Duplicates: Combine UNIQUE with FILTER to get clean unique list without blank spaces: =UNIQUE(FILTER(A2:A, A2:A <> "")).
• Delete Filtered Blank Rows Permanently: Create a filter ➔ filter by Blanks ➔ highlight empty rows ➔ right-click ➔ Delete selected rows ➔ turn off filter!

📚 Related Resources

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