A self-review guide for making spreadsheets clear, professional, and easy to act on.
Core principles
- Optimize for instant comprehension. Make the takeaway visible in seconds.
- Treat defaults as choices. Remove gridlines, borders, colors, and charts that do not serve a purpose.
- Separate data from presentation. Keep source data organized independently from the reader-facing view.
- Keep one source of truth. Derived values should reference inputs rather than being copied manually.
- Separate inputs, logic, and outputs so a reader can understand what changes when an assumption moves.
- Design for the next person. Clear names, frozen headers, consistent formats, and visible assumptions beat tribal knowledge.
- Minimize manual steps. A good sheet should be repeatable, not a one-off document.
Review checklist
- Can a new reader identify the main takeaway in three seconds?
- Is the data organized for the reader rather than merely reflecting how it was assembled?
- Are inputs, calculations, and outputs clearly separated?
- Are headers, dates, numbers, percentages, currency, and units consistent?
- Are panes frozen so context survives scrolling?
- Are columns wide enough and rows tall enough to read without manual resizing?
- Is color used sparingly for emphasis rather than decoration?
- Are gridlines and borders removed unless they communicate hierarchy or grouping?
- Are formulas, links, and assumptions easy to inspect?
- Is there anything that can be removed without losing meaning?
Recommended presentation pattern
Use a clear title and subtitle, a compact summary or takeaway area, a well-labeled main table, and separate supporting tabs for source data or calculations. Apply the same formatting conventions throughout the workbook. Never sacrifice accuracy or traceability for visual polish.