Blog
The sheetXtend blog
Notes on modeling faster in Google Sheets.
-
Formula Tracer · Google Sheets
How to trace formula dependencies in Google Sheets
Every serious model hits the same wall: you click a cell, see =VLOOKUP($B$2,'Raw Data'!A:E,4,0), and have no idea what actually feeds it. Sheets shows you the formula — but not the trail.
-
Quick Stats · Google Sheets
Get sum, average, and count for any selection in Google Sheets
You select a range of numbers and glance down for the total — and Google Sheets gives you Sum ,Count and few other stats, in the status bar. handdy, but it comes with a catch.
-
Brush Plus · Google Sheets
How to copy formatting in Google Sheets (and reuse it anywhere)
That header style you rebuild every quarter — bold, rose fill, top border, currency format. Sheets has a "paint format" roller that copies it, but it's a one-shot tool with no memory. Copy, click, done — and next month you copy it again.
-
Smart Indexer · Google Sheets
How to reorder and manage sheet tabs in Google Sheets
At ten tabs, reordering is a drag. At thirty, it's a hunt: you can't even see the tab you're trying to move, and the destination is off-screen. Google Sheets gives you drag-and-drop and nothing faster.
-
Cell Spotter · Google Sheets
Find any value and pin cells across tabs in Google Sheets
In a 200-column sheet, clicking a cell is disorienting: you know the value, but not which row or column you're in without tracing up and left to the headers. And Ctrl+F finds a value — then drops you there with no map.