Skip to content

With a Header

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

Key points

Choose ARRAY-HEADER
Enter the header
Copy it

In ARRAYFORMULA Builder you can show a header in row 1 and fill results below it.

Steps

Choose ARRAY-HEADER
Enter the header
Copy it

Pasted into the header cell, one formula completes the column.

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