Because it is tax-deductible. The paper charge cuts taxable income, so it shields tax; cash saved = charge × tax rate. Today we leave the numbers and build the instrument you will trace them in.
The no-mouse contract, and the settings baseline that makes every workbook behave the same.
Already mouse-free and F4-fluent? Skip to the keystroke autopsy ↓
Two analysts rebuild the same schedule from scratch. One is the faster typist but reaches for the mouse to move and select. The other types slower but never touches the mouse. Who finishes first?
Commit to a guess first — then read on. The answer says something about where the time in modeling actually goes, and it is not where most people think.
Before you build a single model you make one decision that shapes every hour after it: whether your hand lives on the keyboard or drifts to the mouse. It sounds like a preference. It is the difference between an analyst who can rebuild a schedule under a partner's eye at 11 p.m. and one who cannot. The keyboard is not a party trick for the fast-fingered; it is the discipline that keeps your work accurate, and speed is the byproduct.
Here is why the mouse costs you, and it is not the seconds. Modeling time is dominated by navigation and selection, not typing: jumping to the bottom of a column, grabbing the range you want, stepping into a cell to edit it. Every time you reach for the mouse you break eye contact with the numbers, hunt for a target, and risk selecting one cell off. The keyboard keeps your eyes on the model and your selections exact. That is the whole case: fewer round-trips, fewer mis-clicks, an unbroken line of attention.
The no-mouse contract is short. To move, you jump by data region, not by scrolling: Ctrl+↓ lands you on the last filled cell of a column, however many thousand rows down, in one press. To select, you add Shift: Ctrl+Shift+↓ grabs everything from here to that edge. To edit in place, F2 drops you into the cell without a double-click. To lock a reference while you write a formula, F4 stamps the dollar signs for you. And to reach any ribbon command without the mouse, tap Alt and Excel paints a letter on every button — the KeyTipsTerm of artPress Alt and Excel overlays an access-key letter on each ribbon tab and command. Type the letters in sequence to fire the command — e.g. Alt, H, then the fill-color key — entirely from the keyboard. system that makes the whole ribbon keyboard-drivable.
The win is not fast fingers. It is never leaving the keyboard, so your eyes never leave the model.
F4. With the cursor on a reference while editing, F4 stamps it absolute ($A$1), and pressing it again cycles the lock: $A$1 → A$1 → $A1 → A1 (all-locked, row-locked, column-locked, free). It is the highest-yield keystroke in modeling because mixed references are what make one formula copy correctly across a whole grid.
Take the ordinary moves you make a hundred times a day and put the mouse way beside the contract. The point is not to memorize a list — it is to feel how much scrolling, dragging, and hunting the keyboard simply deletes:
| What you need | The mouse habit | The contract |
|---|---|---|
| Reach the bottom of a 5,000-row column | Scroll, scroll, overshoot, scroll back | Ctrl+↓ |
| Select that whole column of data | Click, drag past the screen fold, hope | Ctrl+Shift+↓ |
| Edit a cell without retyping it | Double-click, then aim the caret | F2 |
| Lock a reference to $A$1 | Type four dollar signs by hand | F4 |
| Paste only the values, not the formatting | Right-click → hunt the paste menu | Ctrl+Alt+V |
Discipline is not only your hands; it is making every workbook start from a known state so nothing surprises you later. Three settings pay for themselves immediately. Know your calculation modeSettingFormulas > Calculation Options. Automatic recalculates on every change; Manual holds until you press F9. Large models run Manual so a single edit does not freeze the sheet — but a stale Manual model shows old numbers, so know which mode you are in.: automatic recalculates on every edit, manual waits for F9, and a model left on the wrong one either crawls or lies. Keep Ctrl+` (the grave accent) in your fingers — it flips the sheet between showing values and showing every formula, the fastest audit view there is. And freeze the header row (View → Freeze Panes) so labels never scroll away from the numbers they name. This is the spirit the FAST standardReferenceA public, Creative-Commons financial-modelling standard: Flexible, Appropriate, Structured, Transparent. Its through-line is that a model must be legible to someone who did not build it — the same reason keyboard discipline and a known baseline matter. is built on: a model has to be legible and predictable to someone who did not build it, and that begins with you.
You are on the first cell of a column and want to select every cell down to the last row of contiguous data — in one motion. You press:
The assumption: "Keyboard shortcuts are about typing faster." So people who type quickly decide they do not need them.
Why it's wrong: the shortcuts barely touch typing — they replace navigation and selection, which is where modeling time and modeling errors actually live. A mouse round-trip pulls your eyes off the numbers and invites a one-cell miss; the keyboard keeps your gaze fixed and your range exact. The rule to carry: you adopt the no-mouse contract to be accurate and auditable, and the speed follows on its own. That is why partners can tell a trained analyst from across the room — the hands never leave home row.
Your turn · write the lock
=B2*$C$2. Only C2 gets locked, because it must point at the one rate cell as the formula travels down; B2 stays free so it steps to B3, B4, and so on. You stamp the lock with F4: while editing, put the caret on C2 and press F4 once to make it $C$2. (Press F4 again and it would cycle to C$2, the wrong lock here.)
Open a scratch workbook and type a tiny schedule: a header row and three columns × ten rows of made-up numbers, with a total row. Now set the mouse aside and, keyboard only, do all of it: jump to the data edges with Ctrl+arrows, select the block with Ctrl+Shift+arrows, write one formula that locks a reference with F4, toggle Ctrl+` to audit your formulas, and freeze the header row. Time it, then delete it and do it again.
Right result: the second pass is faster than the first and you never touched the mouse. That gap — run one, run two — is the skill compounding.
≈ 10 minutes · a scratch workbook, no data needed · this is toolkit card E1's proof in miniature
Before you scroll on — in one sentence, what is the single thing to remember?
The no-mouse contract isn't about fast fingers — it keeps your eyes on the model and your selections exact, and that is what makes you fast and auditable under pressure.
Sources