6.1 Shortcuts, Setup, and Navigation

Keyboard-First Modeling on a Timed Excel Exam

The Corporate Finance Institute (CFI) FMVA final is a three-hour, 50-question online exam. Excel is about 10% of the estimated topic weight, and the paper also includes Excel modeling case studies. CFI's exam article (updated 4 March 2026) tells candidates to spend less than 3 minutes on a typical multiple-choice item and about 45 minutes per case study (60 minutes at most). Microsoft Excel 2016 or newer is required. The timer cannot be paused.

Those constraints change how you use Excel. A case that takes 70 minutes because you scrolled with the mouse, hunted for hardcoded numbers by eye, and clicked between sheets will crowd out the rest of the exam. Keyboard-first modeling is not a style preference. It is how you keep 45-minute cases inside 45 minutes and still have time to audit.

Keyboard-first means: move, select, edit, freeze, group, and open extra windows without taking your hands off the keyboard for routine work. The mouse is for charts and occasional right-clicks, not for walking down 12 forecast years.

CFI Exam-Article Window and Ribbon Shortcuts

CFI's FMVA final-exam article publishes a short, exam-specific list for multiple windows of the same workbook and for minimizing the ribbon. Treat these as CFI's published exam-day shortcuts. Do not treat every Excel hotkey on the internet as "CFI official."

Why new windows matter: CFI's article says to use multiple windows for the same sheet to check your work. Window 1 can sit on the assumptions block (tax rate 25%, WACC 9.5%, revenue growth 6%). Window 2 can sit on the three-statement output. You change WACC in one window and immediately see equity value move in the other — without scrolling away from either region.

Arrange (ALT W A / Command+Option+B) tiles those windows so they do not hide each other. ALT W W on Windows opens the sheet list; on Mac, Command+Control+Arrows moves across sheets. CTRL+F1 / Command+Option+R collapses the ribbon so a laptop screen can show more rows of the model.

CFI also tells you to keep a blank Excel sheet open for calculations and to break the calculation into steps. On exam day that scratch sheet is for a WACC build or a mid-year DCF check, not for rewriting the case model.

Standard Excel still applies for everything else. Ctrl+Page Up / Ctrl+Page Down (Windows) also moves sheets. Ctrl+Tab moves among workbooks. Those are ordinary Excel, not extra CFI-branded commands. On exam day, prefer the article's ALT W W / Command+Control+Arrows when you are already in the View KeyTips flow CFI published.

Freeze Panes, Split, and What You Should See

Freeze panes locks rows and/or columns so headers stay visible while you scroll the forecast. In a typical FMVA layout, row 8 holds years 2024–2033 and column A holds line names (Revenue, COGS, EBIT). Freeze below the year row and to the right of the labels. If you do not freeze, you will type a 2031 formula while looking at 2026 labels.

How to freeze (standard Excel, not a CFI-only list):

1. Select the cell below the rows you want frozen and to the right of the columns you want frozen. Example: freeze years in row 8 and labels in column A → select B9.
2. View → Freeze Panes → Freeze Panes. On Windows KeyTips this is Alt, W, F, F.

Freeze top row is the one-click version when only headers need locking. For a three-statement model, freeze both the header row and the stub column.

Split is different. Split creates independently scrollable regions of the same window. Use split when you need the 2024 historical column and the 2033 terminal column visible together but you do not want a second window. Freeze is for labels; split is for two data regions; new windows (the CFI article method) are for two distant sheets or for assumptions versus output.

Worked setup: Apex three-statement file

You open Apex_3Stmt.xlsx. Assumptions sit on a sheet named Assumptions in B4:B12 (WACC 9.5%, tax 25%, terminal growth 2.5%). The IS sheet has years in row 8, stubs in column A, and forecast formulas in D9:M80.

1. On IS, select B9 → freeze panes. Years and stubs stay put.
2. ALT W N (Windows) or Command+N (Mac) opens a second window. Point that window at Assumptions.
3. ALT W A / Command+Option+B tiles them.
4. CTRL+F1 / Command+Option+R if the ribbon is eating the laptop screen.

You can now change tax from 25% to 21% and watch EBIT × (1 − t) and NOPAT update without losing the income-statement context. That is the exam-article workflow, not a formatting trick.

Ctrl+Arrow, Selection, and Go To Special

Ctrl+Arrow (Windows) jumps the active cell to the edge of a contiguous block in that direction. From A9 in a filled stub column, Ctrl+Down lands on the last labeled line, not on row 1,048,576. On Mac, Command+Arrow is the usual equivalent in Excel — common Excel, not an extra CFI exam-article command.

Ctrl+Shift+Arrow extends the selection to that edge. That is how you highlight D9:M9 (one formula row across years) without click-dragging and missing 2033.

Go To Special (from Go To, then Special; Windows often F5 then Alt+S) selects cells by type: constants, formulas, blanks, visible cells only, row differences, column differences, precedents.

Worked example: hunt hardcoded growth

Apex revenue in D12:M12 should all be =C12*(1+Assumptions!$B$5) or a year-specific growth named range. A reviewer suspects 2028 is hardcoded.

1. Select D12:M12.
2. Go To Special → Row differences (with D12 as the active cell). Excel highlights any cell whose formula does not match D12's pattern.
3. Or Go To Special → Constants on the whole IS sheet. Every leftover 0.06 typed into a formula row lights up.

That is faster and more complete than scanning with the mouse. On a 45-minute case, Go To Special → Constants is how you find the 6% that should have been a named assumption.

Visible cells only (Windows often Alt+; after a filtered or grouped range) stops you from pasting over hidden rows. If you copy a grouped P&L and paste without visible-cells-only, you can overwrite 40 hidden monthly rows and not notice until the balance sheet breaks.

Ctrl+End is the other hygiene check. If the used range is at column XFD, someone formatted or accidentally edited a far-off cell. Jump there, clear it, and save. A bloated used range slows every Go To Special pass.

F2, F4, and Absolute References

F2 (Windows) opens the active cell for editing and shows color-coded precedents. On many Mac keyboards the F-keys are captured by the OS; CFI's public Excel shortcut sheet lists Ctrl+U as the edit-active-cell equivalent. Use F2 (or Ctrl+U) before you rewrite a formula so you can see whether the reference is $B$5 or B5.

F4 while the cursor sits on a reference cycles:

B5 → $B$5 → B$5 → $B5 → B5

CFI's public Excel shortcut sheet lists Command+T on Mac for toggling references. F4 outside of edit mode repeats the last action (for example, repeating a fill color) — a different function. Exam questions about mixed references mean the in-formula cycle, not Repeat.

• Relative B5: copy one column right becomes C5. Copy one row down becomes B6.
• Absolute $B$5: always the tax rate, WACC, or share count.
• Mixed row-absolute B$5: lock the assumption row, let the column walk.
• Mixed column-absolute $B5: lock the stub column, let the row walk.

Worked example: price × volume grid

Volume sits in C10:G10 (2024–2028). Price sits in B11:B15 (Product A–E). Revenue in C11 should be volume × price.

• Wrong: =C10*B11 copied right becomes =D10*C11 — C11 is empty, revenue is zero.
• Right: =$B11*C$10. Copy across years and down products. Product D in 2027 is $B14*F$10.

For a single growth rate in Assumptions!B5, the income-statement formula is =C12*(1+Assumptions!$B$5) filled right. Without $, year 2 multiplies by C5 (perhaps a COGS % or a blank) and revenue explodes or goes to #VALUE!.

Exam trap: people memorize "hit F4 three times" without looking. One F4 from B5 gives $B$5, which is correct for a tax rate. Three F4s from B5 give $B5, which is correct for a stub but wrong for a single-cell assumption. F2, look at the dollars, then fill.

Grouping Versus Hiding

Grouping (Windows often Shift+Alt+Right to group, Shift+Alt+Left to ungroup; Data → Group) puts a +/− outline on rows or columns. You can collapse monthly detail and leave annual totals visible. The data is still there for audit.

Hiding (right-click Hide, or Ctrl+9 for rows) removes the rows from view without an outline cue that is as obvious. Hidden rows still calculate. They also still get overwritten if you paste into the parent range without visible cells only.

CFI-style models group supporting schedules (depreciation by asset class, debt draws by tranche) and keep the three statements ungrouped and visible. Do not hide input cells. An examiner — or you, 20 minutes later — must see the 9.5% WACC.

If a case file arrives with hidden columns between 2027 and 2029, unhide or ungroup before you fill formulas. Filling across a hidden 2028 column is a classic way to write a formula you cannot see and then wonder why 2029 is wrong.

Why Mouse-Heavy Work Fails Timed Case Studies

Mouse-heavy work fails for four exam-specific reasons:

1. Time. Click-dragging D12:M12 ten times in a case burns minutes. Ctrl+Shift+Right does it in one motion.
2. Selection errors. A drag that stops at 2032 instead of 2033 leaves 2033 as a stale hardcoded value. The model "almost" works.
3. Lost context. Scrolling the assumptions off-screen is how you change the wrong year. Dual windows (ALT W N / Command+N) exist so you do not scroll.
4. Audit holes. You cannot mouse-eye every constant. Go To Special can.

If a case is still incomplete at 60 minutes, CFI's own pacing advice is to mark it and return if time remains. Keyboard-first modeling is what makes "return if time remains" a realistic plan instead of a hope. The 10% Excel domain is not a trivia quiz about the ribbon. It is whether you can set up a file, move through it, and trust the selection you just filled — in the same three hours that also test finance, modeling, and valuation.