What is a good description example for a named range in Google Sheets?

A useful named range description includes what the value represents, where it originates, and any range or constraint that applies. For example: "WACC — blended post-tax; 60% equity × 14.2% CoE + 40% debt × 5.1% CoD × (1–27% tax rate). Source: WACC!B12." That gives the next analyst full context without requiring them to open the source tab. Access the description field via Data → Named ranges → edit (pencil icon).

Where do I add descriptions to named ranges in Google Sheets?

Go to Data → Named ranges, then click the pencil icon next to any range. The description field appears directly below the name field. As of April 2026, descriptions render as hover tooltips in cells that reference the named range. Google's official documentation is at support.google.com/docs/answer/63175.

What's the difference between a cell note and a cell comment in Google Sheets?

A cell note (Insert → Note, or Shift+F2) is private freeform text attached to a cell — visible on hover, no @mentions, no notification emails. A cell comment (Ctrl+Alt+M) starts a threaded discussion with reply chains and notifications. For financial model documentation, notes are the better choice: they're lighter, don't generate inbox noise, and don't leave a trail of resolved comment threads cluttering the model.

How do named function descriptions work in Google Sheets?

Named functions (Data → Named functions) let you write both a function-level description and per-argument descriptions. The function description explains what the calculation does; argument descriptions specify what each input expects — including sign conventions, which matters for inputs like capex or delta NWC that are easy to enter incorrectly. These descriptions surface as autocomplete hints when you type the function name in any formula. Google's named functions documentation confirms this feature has been generally available since 2021.

Should I use cell notes or named range descriptions for model documentation?

Both, for different purposes. Named range descriptions document what a value *represents* across the model — they appear wherever the named range is referenced. Cell notes document a specific value *at a specific point in time* — ideal for one-time items, data source confirmations, or manual overrides. In a multi-tab financial model, named range descriptions are higher-leverage because they scale: one description on `EBITDA_Multiple` surfaces automatically in every formula across every tab that references it.

Google Sheets Description Examples for FP&A Models

They're not decoration. When a VP asks why the EBITDA multiple shifted between the November and December board packs, the analyst with good descriptions answers in 20 seconds. The analyst without them spends 30 minutes retracing the formula chain.

Why Assumption Labels Are Your First Description Example

The most visible description in any model is the cell label to the left of your assumption inputs. Most are too short to be useful.

What You Typed	What You Should Have Written
WACC	WACC — blended, post-tax (source: WACC!B12)
Rev Growth	Revenue growth YoY — FY2026E base case
Margin	Gross margin % — FY2025A actuals = 38.5%
Multiple	EV/EBITDA exit — 10.0x–16.0x range, base = 12.5x

The pattern: name — qualifier — anchor. Name says what it is. Qualifier says which version or scenario. Anchor says where it came from or what reality-checks it.

This matters most in multi-tab models where Assumptions!B7 feeds FCFF calculations three sheets away:

=SUMIFS('P&L'!D:D, 'P&L'!B:B, ">="&Assumptions!$B$3, 'P&L'!C:C, "Revenue")
  * (1 - Assumptions!B7)  ' B7 labeled: "Gross margin % — FY2025A actuals = 38.5%"

When B7 is labeled clearly, the next analyst doesn't have to trace the chain to understand what they're editing or breaking.

Named Range Description Examples: The Field Nobody Fills In

Google Sheets has a description field in the named ranges dialog that almost nobody uses. According to Google's Workspace documentation on named ranges, you can add a description alongside every named range — but the field is buried enough that most people skip it. As of April 2026, these descriptions surface as tooltips when you hover over a cell that references the named range.

For a bank syndicate DCF with 8+ linked tabs, your named ranges might look like this:

Name	Range	Description Example
WACC_Base	WACC!B12	Blended post-tax; 60% equity × 14.2% CoE + 40% debt × 5.1% CoD × (1–27% tax)
RevGrowth_FY26	Assumptions!C4	FY2026E revenue growth rate; base case 18.3%, tied to sales pipeline coverage
TerminalGrowth	DCF!B45	Long-run growth for terminal value; range 2.0%–3.5%, base = 2.5%
EBITDA_Multiple	Assumptions!B22	EV/EBITDA exit multiple; comp set median 12.5x, range 10.0x–16.0x

The description travels with the range name. When you type =RevGrowth_FY26 in any formula on any tab, anyone hovering over it reads the full context without navigating to Assumptions.

Named Function Description Examples: Documenting the Logic, Not Just the Label

Google added named functions to Sheets in 2021, with continued refinements documented in Google's named functions reference. You define a custom function once under Data → Named functions and reuse it across sheets. What most analysts miss: the dialog has both a function description field and per-argument description fields.

A named function for unlevered free cash flow, fully described:

Field	What to Write
Function name	UFCF
Function description	Unlevered FCF from NOPAT components. Excludes financing items. Use for DCF enterprise value builds.
Arg: nopat	Net operating profit after tax — pull from P&L!D row labeled NOPAT
Arg: d_and_a	D&A add-back — source Operations!E column
Arg: capex	Capital expenditures (enter as negative) — source CapEx!C column
Arg: delta_nwc	Change in NWC (negative = cash outflow) — source NWC!D column

Once defined, =UFCF(P&L!D14, Operations!E14, CapEx!C14, NWC!D14) is self-documenting across all 12 periods of a quarterly board pack. The analyst inheriting this model doesn't have to guess whether capex goes in positive or negative — the argument description says so.

Cell Notes as Description Examples for Audit Trails

Cell notes (Insert → Note, or Shift+F2) attach freeform text to a specific cell. They're different from named range descriptions because they document a point-in-time value, not a range definition.

The best use in financial models: flagging one-time items inline.

Q1 actuals show $4.2M revenue against a $3.8M budget. The $400K variance includes a one-time contract that won't recur. Without a note, the next analyst marks it as a structural beat in the runway sensitivity model. With a note on the Q1 actuals cell:

"$4.2M includes $380K one-time contract (Acme Corp, closed 2025-03-15). Recurring run-rate: $3.82M. Exclude from trend and contribution margin by SKU analyses."

That takes 20 seconds to write. It prevents a 30-minute call with the FP&A director during board prep.

Cell notes also work well for tracking data provenance when =IMPORTRANGE() brings in values from external workbooks:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/[ID]", "Actuals!C2:C14")

Note: "Source: Workday HR export, refreshed monthly. Last confirmed: 2026-04-01."

The AI Description Layer: Telling ModelMonkey What Your Model Means

The 4 structural description fields above all communicate to humans. There's a fifth layer that matters in 2026: describing your model's context to an AI working inside the spreadsheet.

ModelMonkey's Custom Instructions field (up to 4,000 characters) lets you write a standing description of your model's conventions before any conversation starts. The built-in Financial Analyst persona example reads:

"I'm a financial analyst working with LBO models and valuations. Use GAAP standards, format currency with thousand separators, percentages with 1 decimal, and dates as MM/DD/YYYY. Keep explanations concise and data-driven."

That instruction set works exactly like a named range description — it supplies context that would otherwise have to be reconstructed from scratch on every question. A more complete version also describes model-specific conventions: which tab holds the single source of truth for WACC, whether the model uses beginning- or end-of-period timing, whether EBITDA is pre- or post-SBC.

An AI without that context guesses. An AI with it gives a useful answer in 3 minutes instead of requiring 30 minutes of back-and-forth clarification.

In summary: Google Sheets gives you 4 native description layers — assumption labels, named range descriptions, named function argument docs, and cell notes — plus a fifth AI-context layer. None of them is difficult to write. All of them pay off the first time someone (including future you) opens the model cold and needs to understand what they're looking at.

Try ModelMonkey free for 14 days — it works in both Google Sheets and Excel.