To make a spreadsheet understandable later, keep changeable assumptions in labeled input cells, reference those cells in formulas, and attach a short note or comment to the formula cell explaining the reasoning and limits. On a Mac, Excel calls simple annotations “notes” and supports threaded comments for discussion; Numbers uses comments on table cells. This keeps the calculation visible and its context close by, without hiding assumptions inside unexplained constants.

Put changeable assumptions in their own cells

Start by finding a formula whose result depends on an assumption: a rate, date, threshold, forecast period, or unit conversion. Put each value that someone may revise in a nearby, clearly labeled input cell. For example, place “Hourly rate” in B2 and an illustrative value such as 40 in C2, then calculate four hours of labor in C3 with =4*C2. The number 40 is an example only; use the value supported by your own source or decision.

Referencing a cell makes the formula respond when that input changes, whereas typing the value directly into the formula leaves the assumption harder to locate and revise. Microsoft documents that using cell references lets you change values without rewriting the formula. Use Excel as your calculator in Excel for Mac

If the time period, source, or unit matters, include it in the label or a neighboring cell: “Hourly rate (USD, Jan 2026)” is more useful than “Rate.” When an input is derived from another value, record that dependency too. Don’t describe an assumption as a verified fact unless you have a source for it.

Add an annotation in Excel for Mac

For a personal explanation attached to a formula, select the formula cell, Control-click or right-click it, choose New Note, and write a concise explanation. Microsoft also documents Shift+F2 as the shortcut to add a note. Click another cell when done. To revise it later, open the cell’s context menu and choose Edit Note. Excel displays an indicator for cells with notes by default; you can change display behavior in Excel > Preferences > View. Menu labels can vary by Excel version. Insert comments and notes in Excel

A good note answers what the formula assumes and where that assumption came from. For the example above, a useful note could say: “Uses 4 hours as the planning estimate; hourly rate in C2 is an illustrative input pending confirmation.” If the four hours are also likely to change, put them in a labeled input cell and reference that cell too. Keep the note about rationale and scope, not a duplicate of the formula’s arithmetic.

Use New Comment when collaborators need to reply or discuss the assumption. In Excel, comments are threaded conversations, while notes are simple annotations. A comment can be useful for an unresolved question, but it does not replace recording the current input and its source in the sheet. Insert comments and notes in Excel

Add a comment in Numbers on Mac

Numbers documents comments attached to table cells. Select the formula cell, click the Comment button in the toolbar, enter the explanation, and click Done. A triangle in the cell corner marks a comment. To review it, click the marker; to show or hide comments, use View > Comments. Numbers comments can be included when printing, but they do not appear in printouts unless that option is selected. Add and print comments in Numbers on Mac

The annotation in Numbers should follow the same pattern: name the assumption, state its basis or source, and note any condition that could change it. For example: “Four hours is a planning estimate; replace after confirming scope.” Keep the editable hour estimate in a cell referenced by the formula so the assumption remains visible in the table. Apple’s documentation describes cell comments; it does not establish a separate Excel-style “New Note” command in Numbers.

Check the explanation before sharing

Select each important formula and confirm that its inputs are labeled, its units make sense, and its annotation explains the decision behind any remaining fixed value. In Excel, the formula appears in the formula bar while the cell displays its result; the formula bar can be shown from View > Formula Bar if it is hidden. Show and print formulas in Excel for Mac

Then change one input temporarily and confirm that the dependent result updates as expected. Restore the intended value afterward. This is a practical check of the relationship in the sheet, not proof that the assumption itself is correct. For any copied formula, review its references: Excel notes that relative and absolute references can behave differently when a formula is copied. Copy and paste a formula to another cell or worksheet in Excel for Mac

Before sending a printed spreadsheet, check whether annotations will travel with it. Numbers offers a print-comments option; in Excel, comments and notes have separate print guidance. If recipients need to evaluate the assumptions on paper, include the relevant notes or summarize them in clearly labeled worksheet cells as well. Print comments and notes in Excel

The resulting sheet should let a reader trace the calculation from labeled input, through formula, to result—and find the reason for the assumptions at the cell that uses them.

Sources