Skip to content

Keeping Blank Rows Empty

Published: Oct 19, 2026 | Updated: Oct 19, 2026 | About (Japanese)

Key points

Choose ARRAY-BLANK
Enter the formula
Copy it

In ARRAYFORMULA Builder you can build a formula that leaves rows without data empty.

Steps

Choose ARRAY-BLANK
Enter the formula
Copy it

IF checks whether the first column is empty.

Use "Build an ARRAYFORMULA" (free)

Tools that go well with this

Build a QUERY Formula: Build a QUERY formula.
Build a FILTER Formula: Build a FILTER formula.
Build an IF Formula: Build an IF formula.

If this guide helped, a small tip would mean a lot.

Send a tip (¥300)Send a gift (Amazon wishlist)

More guides for this tool