How to Record Excel
Record Excel with readable cells and visible formulas. Guide for spreadsheet tutorials, pivot table demos, and report walkthroughs at 150% zoom.
When you’d need to record Excel
Formula and function tutorials
Record yourself building VLOOKUP, INDEX/MATCH, pivot tables, or complex nested formulas. The formula bar, cell references, and result all need to be visible simultaneously — impossible to teach with screenshots alone.
Dashboard and report walkthroughs
Walk stakeholders through a spreadsheet report — which cells to update, how filters work, where to find specific metrics. Record once, share with everyone who asks 'how do I use this spreadsheet?'
Data cleanup process documentation
Record your data cleanup workflow — find/replace, text-to-columns, removing duplicates, conditional formatting. New analysts replicate your process instead of figuring it out from scratch.
Macro and VBA demonstrations
Record a macro running on a dataset — show the before state, run the macro, show the after state. VBA tutorials need the code editor and spreadsheet visible simultaneously.
Recommended settings
Things to know
- •Excel cells contain tiny text — column headers, cell values, formula bar content are all 11-12px by default
- •The ribbon toolbar takes up ~15% of the screen. Collapse it (Cmd+Option+R on Mac) if you won't switch tabs during recording
- •Scrolling through large datasets happens fast — 10,000 rows fly past in a second, viewers can't read anything
- •Recent files list shows file names and paths that may reveal confidential project names or client data
Step-by-step
- 1
In Screenify Studio, select Window Capture and pick the Excel window.
Enable cursor highlight — Excel's active cell indicator is a thin green border that blends into gridlines on dense sheets.
- 2
Open Excel and your spreadsheet. Increase the zoom level to 125-150% (View > Zoom or Cmd+= multiple times). Excel's default zoom shows cells at sizes too small to read in a recording.
- 3
Freeze the header row if you'll scroll through data: select row 2, then View > Freeze Panes > Freeze Top Row. This keeps column headers visible when you scroll, so viewers always know which column they're looking at.
- 4
Collapse the ribbon if you won't switch ribbon tabs during recording: double-click any ribbon tab or press Cmd+Option+R on Mac. This reclaims ~100px of vertical space for your data.
- 5
Start recording. When clicking into a cell with a formula, pause and look up at the formula bar — this is where viewers read the formula. Point out the formula bar explicitly the first time: 'notice the formula bar here shows...'
For pivot tables and VBA recordings
- 6
For pivot table tutorials, start with the source data visible, then Insert > PivotTable. Show the empty pivot table and the Field List side panel. Drag fields one at a time into Rows, Columns, Values — pausing after each to show the result update.
- 7
When demonstrating conditional formatting, zoom into the affected range BEFORE applying the rule. Apply the rule, then zoom out to show the full effect. Applying formatting at full zoom means viewers can't see individual cells changing.
- 8
For VBA tutorials, open the VBA editor (Alt+F11 on Windows, Tools > Macro > Visual Basic Editor on Mac). Arrange the editor and spreadsheet side by side using Split View. Increase the VBA editor font size in Tools > Options > Editor Format.
Pro tips
Auto-zoom on the formula bar. Excel formulas can be 200+ characters long, displayed in a single-line bar at the top of the screen in 11px font. When you click a cell with a complex formula, auto-zoom catches it and zooms in so viewers can actually read `=INDEX(Data!$B$2:$B$1000,MATCH(1,(A2=Data!$A$2:$A$1000)*(B2=Data!$C$2:$C$1000),0))`.
Zoom to 150% before recording. This is the single most impactful change. Default Excel zoom (100%) renders cell values at ~11px. After video compression, that's unreadable. 150% makes every cell value, header, and formula bar content watchable.
Freeze panes to anchor context. If you scroll through 500 rows and the header row disappears, viewers have no idea what column D means. Freeze the header row. If you're working in a specific section, freeze both the top row and the leftmost column.
Narrate cell references aloud. When typing a formula, say 'B2 through B100' as you type `B2:B100`. Excel formulas are a foreign language to many viewers — the cell reference `$A$2` means nothing without narration explaining 'dollar signs mean absolute reference'.
Common mistakes
Recording at default zoom (100%). Cell values at 100% zoom are 11px text. After video compression and viewing on a laptop screen, your viewers are squinting at a grid of gray blurs. Zoom to 150% minimum before recording.
Scrolling through large datasets at full speed. You flick the trackpad and 5,000 rows fly past in 2 seconds. Viewers see a green blur. Scroll slowly, or better — use Ctrl+G (Go To) to jump to a specific cell and show the range explicitly.
Not showing the formula bar. You click a cell, say 'this uses a VLOOKUP,' and move on. The viewer sees the cell value '42' but never sees the formula. Always pause on the cell and direct attention to the formula bar at the top.
Opening Excel during recording and exposing recent files. Excel's Start screen shows recent file names and paths: 'Q4_Revenue_Confidential.xlsx — /Users/brian/Clients/Acme/'. Open your file before starting the recording.
Related apps
Related guides
Record Software Tutorials
Educators, YouTubers, course creators, and developer advocates who produce instructional content
Record Training Course Content
Course creators, bootcamp instructors, corporate trainers, and educators building learning content on platforms like Udemy, Teachable, or internal LMS
Record Excel with Screenify Studio
AI auto-zoom on clicks, instant captions in 50+ languages, cursor highlighting, and studio-grade export. Free plan, no watermark.
Try Screenify Free
