How Do You Do Keyboard-Only Financial Modeling in Excel on Mac?

Quick Answer: Switch on standard function keys, then build the model with Command+Arrow to move, F2 to edit, Command+T to lock references (it works without the Fn key), Control+D and Control+R to fill, and Control plus the grave accent key to audit formulas. Excel for Mac has no shortcut for Data Table, so build the sensitivity grid with plain formulas instead, as shown in Step 6. The Mac Excel Shortcuts app covers the few commands with no Mac equivalent.

Which part do you need?

  • Setting up a Mac for modeling: start with "Set up your Mac first".

  • Building a DCF from scratch: follow Steps 1 to 6 in order.

  • Only need the keys: jump to the shortcut reference table near the end.

  • Excel for Mac has no Data Table shortcut: go straight to Step 6.

What you will build

A five-year revenue build that feeds a discounted cash flow, laid out on two sheets. The layout is small enough to type in about five minutes, and every number below can be checked against your own sheet.

Sample model cell map
WhereCell(s)What goes there
Revenue sheetB2, B4Year 0 units (10000) and price per unit (25). Hardcoded inputs, blue.
Revenue sheetC3:G3, C5:G5, C7:G7Unit growth (10%), price growth (3%) and EBIT margin (20%) for Years 1 to 5. Inputs, blue.
Revenue sheetC2, C4, B6 to G6Units, price and revenue. Formulas, black.
Revenue sheetC8:G11EBIT, NOPAT, reinvestment and free cash flow. Formulas, black; green where they pull from the Summary sheet.
Summary sheetB3:B6Tax rate 25%, reinvestment 5% of revenue, WACC 10%, terminal growth 3%. Inputs, blue.
Summary sheetB8:B11PV of forecast cash flow, terminal value, PV of terminal value and enterprise value.

The inputs are Year 0 units of 10,000, a price of 25, unit growth of 10%, price growth of 3%, EBIT margin of 20%, tax of 25%, reinvestment of 5% of revenue, WACC of 10% and terminal growth of 3%. With these, Year 5 revenue comes to 466,756 and enterprise value to 563,157. If your sheet matches, your formulas and your keystrokes are right.

Time and skills

About 30 minutes the first time, then a few minutes per model once the keys are automatic. You need basic formula fluency (SUM, NPV) and a working idea of free cash flow and discount rates.

Set up your Mac first

Two settings decide whether the rest of this article works.

  1. Standard function keys. On most MacBooks F2 and F4 trigger brightness or Mission Control unless you hold Fn. In System Settings, open Keyboard and turn on "Use F1, F2, etc. keys as standard function keys". The function keys guide walks through it.

  2. Learn the Command+T fallback. Excel for Mac cycles a reference between absolute and relative with either F4 or Command+T, according to Microsoft's shortcut list. Command+T never collides with a system function, so it is the safer habit on a laptop.

On a compact MacBook keyboard the Home, End, Page Up and Page Down keys sit behind Fn and the arrow keys. That is why Control+Home becomes Control+Fn+Left Arrow.

Step 1: Move around without the trackpad

Fast movement is most of what makes keyboard-only modeling fast. These are the keys you will use every minute.

Navigation and editing shortcuts
ActionMacWindows
Jump to the edge of the data blockCommand+ArrowCtrl+Arrow
Select to the edge of the blockShift+Command+ArrowCtrl+Shift+Arrow
Go to the start of the sheetControl+Home (MacBook: Control+Fn+Left Arrow)Ctrl+Home
Go to the last used cellControl+End (MacBook: Control+Fn+Right Arrow)Ctrl+End
Next / previous sheetOption+Right / Left Arrow, or Control+Page Down / Page UpCtrl+Page Down / Page Up
Edit the active cellF2 or Control+UF2
Go To (jump to a cell or open Special)Control+G or F5Ctrl+G or F5

A useful rhythm on the sample model: Command+Right Arrow runs along a forecast row, Command+Down Arrow runs down a column of drivers, and Option+Right Arrow flips from Revenue to Summary and back.

Step 2: Build the revenue schedule

Type the Year 0 inputs in B2 and B4, then the growth assumptions across C3 to G3, C5 to G5 and C7 to G7. For the formulas, this is the keyboard sequence that avoids retyping:

  1. Select C2, type =B2*(1+C3) and press Return.

  2. Press Shift+Command+Right Arrow to extend the selection to G2, then Control+R to fill right.

  3. Move to C4, type =B4*(1+C5), then repeat the select and fill-right step.

  4. In B6 type =B2*B4, fill right with Shift+Command+Right Arrow and Control+R.

The fill handle also works from the keyboard: see Fill Handle in Excel on Mac for the variants.

The formulas used across the model:

Core formulas
CellFormulaWhat it does
Revenue C2=B2*(1+C3)Units grow by the unit growth rate.
Revenue C4=B4*(1+C5)Price grows by the price growth rate.
Revenue C6=C2*C4Revenue is units times price.
Revenue C9=C8*(1-Summary!$B$3)NOPAT: EBIT after tax. The dollar signs lock the tax-rate cell.
Revenue C11=C9-C10Free cash flow is NOPAT minus reinvestment.
Summary B8=NPV(B5,Revenue!C11:G11)Discounts Years 1 to 5 at the WACC.
Summary B9=Revenue!G11*(1+B6)/(B5-B6)Terminal value at the end of Year 5 (Gordon growth).
Summary B11=B8+B10Enterprise value.

Step 3: Colour code as you go

Use blue for hardcoded inputs, black for formulas and green for links to another sheet. Doing it while you build is far cheaper than recolouring afterwards, and the colours are what let a reviewer see at a glance what can be changed.

Excel for Mac has no single shortcut for font colour. The dependable keyboard route is Command+1 to open Format Cells, then the Font tab, where Tab and the arrow keys reach the colour picker. A quicker pattern: colour one input cell, then copy it and use paste formats (see Paste Special on a Mac) onto the other input ranges. Feel free to use MacCove's Mac Excel Shortcuts App for getting ribbon access.

Step 4: Build the DCF

On the Revenue sheet, rows 8 to 11 turn revenue into free cash flow: EBIT is revenue times margin, NOPAT is EBIT after tax, and free cash flow is NOPAT minus reinvestment. On the Summary sheet, B8 to B11 discount the cash flows and add the terminal value (formulas in the table above).

When you type a reference to another sheet, you can build it from the keyboard: type the equals sign, press Option+Right Arrow to switch sheet, use the arrow keys to select the cell, then press Command+T to lock it before you press Return. That sequence creates references such as Summary!$B$3 without a single mouse click.

Step 5: Audit the model from the keyboard

Three checks catch most errors before anyone else sees the model.

  1. Show formulas. Press Control plus the grave accent key (the key left of 1 on a US layout) to show every formula on the sheet. Look for a row where one cell differs from its neighbours. Press it again to return to values.

  2. Find hardcodes inside calculations. Press Control+G, choose Special, and select Constants in the forecast range. Any number that lights up in a calculation row should have been a formula. The Go To Special guide covers the other options.

  3. Trace what depends on an input. Select an input cell and press Control+] to select the cells that refer to it directly. In Go To Special you can choose Precedents or Dependents for a wider trace.

Note that the Command-plus-grave-accent combination on a Mac switches between open windows of the same app, so it will not show formulas. Excel for Mac uses Control for this one.

Step 6: Run a sensitivity without a Data Table

The usual way to show enterprise value across WACC and terminal growth is Data, What-If Analysis, Data Table. Microsoft documents the Mac steps in its Data Table article, but there is no keyboard shortcut for the dialog, and a Data Table recalculates the whole model for every cell.

A formula grid avoids both problems. Because the terminal value only needs the Year 5 cash flow and two rates, each grid cell can hold the full valuation:

  1. Put terminal growth rates (2.0%, 2.5%, 3.0%, 3.5%) in B14 to E14 and WACC values (9%, 10%, 11%) in A15 to A17.

  2. In B15 enter: =NPV($A15,Revenue!$C$11:$G$11)+Revenue!$G$11*(1+B$14)/($A15-B$14)/(1+$A15)^5

  3. Press Command+T while the cursor is on each reference to set the mixed locks: dollar sign on the column for A15 and on the row for B14. Press Command+T repeatedly to cycle absolute, row-locked, column-locked and relative.

  4. Select B15 to E17 (Shift+Arrow keys) and press Control+D, then Control+R, to fill the grid.

The finished grid should read:

Expected enterprise value grid
WACC / terminal growth2.0%2.5%3.0%3.5%
9%582,633618,969661,362711,462
10%506,229532,796563,157598,191
11%446,918467,014489,622515,244

Add one check cell: =IF(ABS(D16-B11)<0.01,"OK","CHECK"). The centre of the grid must equal the enterprise value from the main calculation. If it shows CHECK, a lock is on the wrong part of a reference.

This works as long as the cash flows themselves do not change with the rates. If WACC or growth drives revenue or margins, you need a real Data Table, which means using the Data tab with the mouse or the menu bar.

Circularity and iterative calculation

Avoid circular references unless the model needs them, such as interest calculated on an average debt balance. If you do need one, enable iterative calculation in Excel, Preferences, Calculation, and add a circuit-breaker input cell (1 for on, 0 for off) that multiplies the circular term. When the model throws errors you set the breaker to 0, errors clear, then set it back to 1.

Shortcut reference: Mac and Windows

Financial modeling shortcut reference
TaskMacWindows
Cycle absolute / relative referenceCommand+T or F4F4
Fill down / rightControl+D or Command+D / Control+R or Command+RCtrl+D / Ctrl+R
Show or hide formulasControl+grave accentCtrl+grave accent
Format CellsCommand+1 or Control+1Ctrl+1
Percent formatControl+Shift+%Ctrl+Shift+%
Currency formatControl+Shift+$Ctrl+Shift+$
General formatControl+Shift+~Ctrl+Shift+~
Enter an array formulaControl+Shift+Return or Shift+Command+ReturnCtrl+Shift+Enter
Select direct dependentsControl+]Ctrl+]
Save a dated copyShift+Command+SF12

Shortcuts are as listed in Microsoft's Excel keyboard shortcut reference. If a combination does nothing, check the function-key setting above first.

Practice drill

Clear the sample sheets and rebuild from the cell map, using only the keyboard. Aim for a result that matches the numbers above.

  1. Type the Year 0 inputs. Press Tab to move right and Return to move down.

  2. Enter the C2 formula, then Shift+Command+Right Arrow and Control+R.

  3. Enter the unit growth row and fill right the same way.

  4. Build row 11 on the Revenue sheet, then switch to Summary with Option+Right Arrow.

  5. Build B8 to B11, using Command+T to lock the tax rate and discount rate references.

  6. Build the sensitivity grid, then Control plus grave accent to check every formula.

Target: Year 5 revenue of 466,756, free cash flow of 46,676 and enterprise value of 563,157. Repeat until you no longer think about the keys.

Model hygiene checks

  • Add a balance or tie-out check. Any model with a balance sheet needs a row that must equal zero. In this DCF, the grid-centre check plays the same role.

  • Keep each row consistent. Fill across with Control+R instead of retyping, so every period uses one formula.

  • Separate inputs from calculations and keep a single cell for each assumption.

  • Avoid hardcodes inside formulas. Use the Go To Special check from Step 5.

  • Save a dated copy with Shift+Command+S before big changes, then paste values only when you send the output (Paste Special).

Where Excel for Mac has no shortcut

Three gaps come up in modeling: opening Data Table, setting font colour in one keystroke, and keyboard access to ribbon commands that Windows reaches with Alt sequences. For ribbon commands, what replaces ribbon access keys in Excel for Mac lists the options. If you work from Windows muscle memory, the Mac Excel Shortcuts app lets you use those Windows shortcuts for the handful that have no Mac equivalent.

If you want X, use Y

  • If you want to change a reference lock quickly, use Command+T instead of F4 so the Fn key never gets in the way.

  • If you want a sensitivity table, use a formula grid like Step 6 unless the rates drive the whole model.

  • If you want to find mistakes in a model you inherited, use Control plus grave accent, then Go To Special, Constants.

  • If you want to move between sheets, use Option plus the left or right arrow.

FAQs

Is F4 the same on Mac and Windows?

F4 does the same job, but on a MacBook it only works without Fn if standard function keys are enabled. Command+T is the Mac alternative and always works.

Why does Command plus grave accent not show formulas?

That combination switches between windows of the same app on macOS. Use Control plus the grave accent key to show formulas.

How do I navigate between sheets quickly?

Use Option plus Right or Left Arrow, or Control+Page Down and Page Up. The sheet shortcuts guide lists more options.

Can I build a Data Table from the keyboard on Mac?

There is no documented shortcut for the Data Table dialog. Build a formula grid as in Step 6, or open the dialog from the Data tab.

What should I check before sending a model?

Show formulas, run Go To Special for constants, confirm your tie-out cell shows OK, then save a dated copy and paste values for the output.

Sources

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.