DazzleDesk guide

How to make a spreadsheet: a small budget, built step by step

15 November 202611 min read
A half-built budget spreadsheet with category rows and a total formula

Reading about spreadsheets is like reading about swimming. So instead of theory, here is a build: a small monthly budget spreadsheet you can make in about fifteen minutes. Follow it once and you will know how to make a spreadsheet for almost anything - a trip plan, a guest list, a savings goal.

In this guideStep 1: Decide the question firstStep 2: Lay out the columnsStep 3: Add the formulasStep 4: Format for reading, not for InstagramStep 5: Make it reusableCommon mistakes (everyone makes these once)

Step 1: Decide the question first

Every good spreadsheet answers one question. Ours: "where does my money go each month?" That question decides your columns: date, item, category, amount. People who start formatting before knowing the question end up rebuilding - write your question at the top of tab one and let it boss the design around.

Some other questions and their natural columns: job hunt (company, role, stage, follow-up date), grocery run (section, item, quantity, price), study plan (subject, topic, due date, status).

Step 2: Lay out the columns

Row 1 is for headers: Date, Item, Category, Amount. Type them in A1 to D1 and make them bold. Then enter five real rows of recent spending. Real data from the start keeps the sheet honest - dummy layouts with fake "Lorem ipsum" rows hide design mistakes.

Keep one rule sacred: one row per entry, no merged cells in the data area. Merged cells look tidy and break every sort, filter and formula you will ever want.

Step 3: Add the formulas

Below your data, type "Total" and next to it =SUM(D2:D6). Now the sheet tracks your spending total as you add rows (extend the range, or use =SUM(D:D) to catch everything).

Add one summary per category: =SUMIF(C:C,"Food",D:D) totals only rows where the category is Food. Copy it for Rent, Travel, Fun. SUMIF is the single most useful budget formula - it turns a pile of rows into a picture.

Finally, a leftover check: put your monthly income in a cell, subtract the total, and label it "left to spend". Watching that number shrink through the month is budgeting.

Step 4: Format for reading, not for Instagram

Bold the headers, freeze row 1 (View, Freeze), format the amount column as currency, and give the summary block one quiet background colour. Stop there. A spreadsheet is a tool; fifteen minutes of extra decorating does not make the numbers kinder.

Step 5: Make it reusable

When the month ends, right-click the tab, Duplicate, clear the entries, rename it to the new month. Twelve tabs later you have a year of records and a yearly total that is one SUM across tabs.

This is also the moment where most people decide whether to keep building or grab something ready. Our budget templates are this same idea carried further - dashboards, charts and a year view, already tested - so if you find yourself enjoying the result but not the building, that is the shortcut.

Common mistakes (everyone makes these once)

Storing numbers as text: if your total shows zero, click a number cell and check the format is Number, not Plain text. Typing inside the formula range: put summaries below or to the right, never inside the data. And the classic: one giant sheet for everything. Separate tabs beat one crowded tab - data on one, summary on another.

Questions people ask

Is it hard to make a spreadsheet?

The budget above takes fifteen minutes the first time and five the second. The learning curve is in knowing what to ask of the sheet, not in the typing.

Google Sheets or Excel for this?

Both work identically for this build. Sheets is free and lives in your Google account; Excel needs a licence. Everything in this guide works in both.

How do I share my spreadsheet?

The Share button in Google Sheets, with view or edit access per person. For a reusable file, share a copy link so everyone gets their own version.

budget spreadsheet templates · the simple monthly budget · a deeper expense tracker

Keep reading

More guides