Recording Spreadsheet Walkthroughs People Can Actually Follow
Make spreadsheet videos clear: zoom on formulas, hide real data, show the formula bar, explain cell references, and structure long models into chapters.
Spreadsheets are the hardest thing to explain on video. A model that makes perfect sense to the person who built it looks like a wall of numbers to everyone else. The cells are tiny, the formula bar is a single thin line at the top, and the one thing that actually matters — why this cell references that cell — is invisible.
Yet spreadsheet walkthroughs are some of the most requested videos in any organization. Finance wants to explain the forecast. Operations wants to hand over a tracker. A teacher wants to show how a formula works. Done well, a five-minute recording replaces a week of back-and-forth questions.
Here is how to make one that people can follow.
Why Spreadsheet Recordings Fail
The failure modes are predictable, which is good news — it means they are all fixable before you press record.
- Text too small: Default spreadsheet font sizes are built for a mouse and a monitor, not for video played in a browser window
- The formula bar is ignored: You click a cell and talk about the formula, but the viewer is looking at the result, not the bar
- Too much on screen: Forty columns and three hundred rows means nothing is readable
- Invisible navigation: You jump to another sheet, another range, another workbook — and the viewer loses their place
- Real data on display: Salaries, customer names, and revenue figures appear in a video that gets shared more widely than you expected
- No structure: A twenty-minute single take through a complex model with no chapters is unnavigable
Prepare the Workbook Before Recording
Treat the recording copy as a separate artifact from the live file. Duplicate it, then prepare it.
- Replace sensitive data with realistic dummy values: Keep the shape of the data — same formats, same magnitudes — but no real names, salaries, or client figures. This is far faster than blurring in post
- Increase the zoom level to 150–200%: Most spreadsheet apps have a zoom control in the corner. Use it. Column widths and font sizes stay intact, everything just gets bigger
- Hide the columns and rows you will not discuss: Fewer things on screen means the viewer looks where you want
- Collapse unrelated sheets or move them to the end: A tab bar with eighteen sheets is intimidating
- Set a clean starting state: Scroll to the top-left of the relevant range, deselect everything, close the sidebar panels you do not need
- Turn off comment indicators and track changes if they clutter the view
Make Formulas Visible
This is the single biggest improvement you can make, and most people skip it.
The formula bar is where the explanation lives, but it is physically far from the cell you are discussing — often at the opposite end of the screen. Viewers cannot watch both. A few techniques solve this:
- Use formula view: Most spreadsheet apps can display formulas in the cells themselves instead of results (
Ctrl+\`` in Google Sheets,Ctrl+“ in Excel). Toggle it on to show the structure of a block, then off to show the numbers - Zoom on the formula bar when you read a formula aloud: A zoom effect on that strip makes a long nested formula legible
- Type the formula live rather than clicking a finished cell: Watching a formula get built, argument by argument, teaches far more than seeing the final version
- Use the range highlighting: When you click into a formula, most apps color the referenced ranges. Pause there — that visual is the explanation
- Say references out loud in plain language: Not “B4 times C4” but “last month’s unit count times the current price”
Zoom Is Not Optional
If there is one effect that spreadsheet videos cannot do without, it is zoom. A spreadsheet is a dense grid where the interesting part is usually three cells wide.
- Zoom into the cell range you are discussing, hold it while you explain, then pull back out so the viewer re-orients
- Pull back for structure, push in for detail: Wide shot to say “this sheet has four sections,” close shot to explain one of them
- Follow the data flow: If input cells are at the top and the result is at the bottom, zoom along that path in the order the calculation runs
- Avoid rapid zoom changes: Each zoom should hold long enough to read what is inside it — two to three seconds minimum
- Keep one zoom level for comparable moments: Jumping between magnifications for similar content feels unsteady
Adding zoom in the editor afterward is usually better than zooming the app while recording, because you can time it to your narration instead of guessing.
Narrate the Logic, Not the Clicks
The most common narration mistake in a spreadsheet video is describing mechanics instead of meaning.
Weak: “I click on cell D12, then I type equals, then SUMIF, open bracket…”
Strong: “This total only counts the rows from the active region, which is what the SUMIF is doing here.”
A reliable pattern for each formula or section:
- What question does this answer? — “How many licenses do we need next quarter?”
- What goes in? — “It takes headcount from the HR tab and the growth rate from this input cell”
- What comes out, and what to watch for — “If this goes negative, the growth assumption is wrong”
Viewers almost never need to memorize your keystrokes. They need to understand the model well enough to change it safely.
Structure Longer Walkthroughs
A full model walkthrough is long by nature. Give it a skeleton.
- Start with a thirty-second map: Show the tab bar, name each sheet’s job, then dive in. Orientation first always pays off
- Record in takes, one section per take: Inputs, calculations, outputs, charts. Short takes are easier to re-record when you misspeak
- Add chapters in the editor:
Overview,Input assumptions,Core calculation,Scenario toggles,Dashboard. Spreadsheet videos get re-watched in pieces, and chapters are what make that possible - Use text overlays for cell addresses and sheet names: A caption reading
Assumptions!B4:B18is much easier to act on than a spoken reference - Keep each section under three minutes where you can; split when a section runs long
Recording Settings That Suit Spreadsheets
- Window capture rather than full screen: Keeps the frame on the spreadsheet and keeps the rest of your desktop out
- 30fps is plenty: The content is mostly static; a lower frame rate leaves more bitrate for sharp text
- Record at native resolution: Scaling up afterwards is where blurry numbers come from
- Keep the webcam small or off: In a grid, a picture-in-picture overlay will cover cells. Bottom corners are where totals usually sit
- Hide the mouse cursor trail effects if your app has them, but do keep a visible cursor — in a spreadsheet, the cursor is the pointer that tells viewers where to look
A Pre-Record Checklist
[ ] Working on a duplicate file, not the live workbook
[ ] Real names, salaries, and client data replaced with dummy values
[ ] App zoom set to 150–200%
[ ] Irrelevant rows, columns, and sheets hidden
[ ] Starting view scrolled to the top-left of the relevant range
[ ] Notifications and chat apps closed
[ ] Formula view shortcut tested
[ ] Section list written down in order
[ ] Ten-second test recording checked for readability at small size
That last step catches almost everything. Record ten seconds, then play it back in a small window — roughly the size a colleague will watch it in. If you cannot read the cell contents comfortably, raise the zoom and record again.
Common Mistakes
- Scrolling while talking: Moving the grid during an explanation makes it impossible to follow. Scroll, pause, then speak
- Selecting ranges with the mouse at speed: The highlight flickers and the viewer sees nothing. Select deliberately, or type the range
- Leaving a filter applied without saying so: Viewers reproduce your steps and get different numbers
- Explaining every formula in a model: Pick the five that carry the logic; the rest is noise
- Forgetting the exported file size: Long spreadsheet videos compress well — there is no reason to ship a 2GB file for a tracker handover
- Recording the whole thing in one take: One stumble at minute eighteen and you start over
Conclusion
Spreadsheet walkthroughs are a readability problem first and an explanation problem second. Duplicate the file, swap in safe data, raise the zoom, hide what you will not discuss, and show formulas in the cells rather than pointing at a thin bar at the top. Then use zoom effects and chapters in the editor to lead viewers through the logic in the order the numbers actually flow. Do that and the tracker you hand over stops generating questions — people watch the five minutes and get on with the work.