Build a spreadsheet you can actually trust.

Preview editorial draft · September 2026

A reliable spreadsheet separates inputs, calculations and results. Good formatting helps people read it; good structure helps them trust it.

Give each column one purpose

For a simple sales sheet, use Date, Item, Quantity, Unit Price and Total. Keep one transaction per row. Avoid blank rows in the middle of the data and do not place two different values in one cell.

Calculate instead of retyping

If Quantity is column C and Unit Price is column D, enter =C2*D2 in E2. Copy the formula down. Use =SUM(E2:E10) to total nine transactions. Check that the last transaction is included.

Understand cell references

A relative reference changes when copied. An absolute reference stays fixed. If a discount rate is in H1, =E2*$H$1 calculates the discount amount using that same rate in every row.

Protect meaning, not just appearance

• Store IDs with leading zeroes as text.
• Use consistent date formats.
• Apply decimal formatting to display values neatly; it does not necessarily change the underlying value.
• Label currency and units clearly.
• Keep an untouched copy of imported data.

Perform three checks

Calculate one row by hand. Check the largest and smallest values. Finally, compare totals with the original source. If a total looks wrong, inspect missing entries, numbers stored as text and formula ranges before changing the formula.