The blog

Field notes from the spreadsheet trenches.

Practical tips, deep dives on Sheets quirks, and the occasional studio update.

AllComparisonTutorial

Go to special google sheets blog post post cover

Go To Special in Google Sheets: select cells by type in one click

Google Sheets has no command to select cells by type. Here is how to grab every blank, formula, or formatted cell — with a helper column, and in one click with Select Special.

Mar 12, 2026 · 6 min read

Read post →

Pivot table vs subtotal rows vs tables in Google Sheets blog post cover

Comparison

Pivot table vs subtotal rows in Google Sheets — and where tables fit in

A pivot table moves your summary to a separate range; subtotal rows keep the totals inside the original table. Here is when each wins, what the native tables group-by view can and cannot do, and how to add subtotal rows in one click.

Jul 12, 2026 · 7 min

Subtotal rows grouped by column in Google Sheets blog post cover

Tutorial

How to add subtotal rows in Google Sheets, grouped by any column

Google Sheets has no one-click subtotal feature like Excel. Here is how to insert grouped SUBTOTAL rows by hand — and how to add them to any table in one click with Table Total.

Jul 5, 2026 · 7 min