Excel has one major advantage over Word for quotations: the math is automatic. Change a quantity or rate and every total updates instantly. Set it up correctly once and you have a template you can reuse for every project with minimal effort.
Here is the complete Excel quotation setup, from blank workbook to finished PDF.
Setting up your workbook
Open a new blank workbook. Rename Sheet1 to “Quote” by double-clicking the tab. If you want to save client details or rate cards on a second sheet for reference, add a second tab called “Data.”
Set print area first. Before you build anything, go to Page Layout > Print Area > Set Print Area. Define it as A1:G50 or whatever range covers your document. This prevents Excel from printing stray data outside your quote layout.
Building the header (rows 1–12)
Use merged cells to create a clean header block. Merge A1:C4 for your logo or business name. Merge E1:G4 for the quote metadata block.
Your details (A1:C4):
Your Name / Business Name
Address Line 1
City, State, ZIP
Email | PhoneQuote metadata (E1:G4):
QUOTATION
Quote #: Q-2026-001
Date: 2026-05-27
Valid until: 2026-06-26In rows 8–11, add the client’s name and address on the left, using a smaller font (10pt) than your own header.
The line-item table (rows 14–30)
Set up column headers in row 14:
| A | B | C | D | E |
|---|---|---|---|---|
| # | Description | Qty | Rate | Total |
Format row 14 with a background color and bold text to distinguish headers from data.
In row 15, enter your first line item. In cell E15, enter: =C15*D15
Copy this formula down to row 29 (or however many rows you need). Lock the formula pattern with absolute/relative references if needed, but for a simple multiplication =C15*D15 is enough.
Protect against blank row errors. Empty rows show $0 in the Total column, which looks messy. Wrap your formula: =IF(C15="","",C15*D15) — this shows nothing in empty rows.
Totals section (rows 32–37)
Place your totals below the line-item table with a clear visual break (bold border or shaded row).
| Subtotal | =SUM(E15:E29) |
| Tax Rate | 0.10 (in a named cell — see below) |
| Tax Amount | =E32*E33 |
| TOTAL | =E32+E34 |
| Deposit (50%) | =E35*0.5 |
| Balance Due | =E35-E36 |
Name your tax rate cell. Click on the cell holding your tax rate (e.g., E33), then in the Name Box (top left, where it says “E33”), type TaxRate and press Enter. Now you can write =E32*TaxRate in your tax formula, which is readable by anyone editing the file. Change the rate in one cell and every calculation updates.
Named ranges are the single most useful Excel skill for business documents. Instead of hunting for which cell holds the tax rate, you name it once and reference it by name everywhere. When your rate changes, you update one cell and the entire document recalculates.
Payment terms and acceptance text (rows 39–50)
In this section, merge A39:G39 through A50:G50 for a text block. Enter your payment terms, validity statement, and acceptance instructions as plain text.
Format this section in a smaller font (9–10pt) and use a top border to separate it from the totals section.
Formatting for a professional look
Excel defaults to a grid-like appearance that looks like a spreadsheet, not a business document. Hide the gridlines (View > uncheck Gridlines) before adding any visual structure.
Use these formatting choices:
- Font: Calibri or Aptos, consistent size (11pt for body, 13pt for section headers)
- Colors: Two at most — one accent for header backgrounds, one for section labels
- Borders: Use them sparingly, only where they add clarity
- Column widths: Column B (Description) should be at least 250px wide to avoid text wrapping awkwardly
Exporting to PDF
Never send the .xlsx file directly. Go to File > Export > Create PDF/XPS. Before exporting, use Print Preview to verify that your print area is correct and nothing is cut off.
Name the PDF clearly: Quote-ClientName-2026-001.pdf.
The limits of Excel for quoting
Excel quotes have no built-in delivery or tracking. You send a PDF and then wait, with no way to know if the client opened it. For freelancers sending a handful of quotes per month, this is manageable. For anyone sending quotes regularly, Waco3 handles the math, formatting, delivery, and open-tracking in one tool—without the PDF export step.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
