Educational
Quoting
Business
How to Stop Your Excel Quote Formatting Breaking When You Send It
It Looked Perfect Until You Hit Send
You spend an hour getting the quote just right in Excel. Columns lined up, totals adding, everything neat. You send it. Then the client replies confused, or you open it on your phone to check, and it is a mess. Columns cut off the edge of the page. Rows split across two pages. The layout has shifted, and the tidy quote you built looks broken.
It is one of the most frustrating things in Excel, because you did nothing wrong. It looked fine on your screen. The problem is that Excel does not lock how a file looks. It reflows based on the screen, the version, the print settings and the paper size on the other end, none of which you control once it leaves your computer.
The good news is there are real fixes that stop most of it, and they are quick. Below are the ones that actually work, and then the honest truth about why Excel keeps fighting you no matter how well you set it up.
TL;DR
Excel quotes break on the client's end because Excel reflows to their screen and print settings, not yours
Real fixes help: set the print area, fit to one page, lock columns, and always send a PDF
The single biggest fix is exporting to PDF, never sending the live Excel file
Even done perfectly, an Excel quote still looks like a spreadsheet to the client
The lasting fix is to keep Excel for pricing and send the quote in something built for it
Why It Breaks in the First Place
It helps to understand the cause, because it tells you which fixes matter. A spreadsheet is a living grid, not a fixed page. When you send the file, the client's Excel redraws it using their settings: their default paper size, their screen, their version, their zoom. Anything that depended on your setup, your column widths, your page breaks, your view, can shift. You are not sending a document, you are sending a set of instructions that get redrawn at the other end. That is why it looks different, and it is why the fixes below are all about locking the layout down before it leaves you.
Builder and Renovator
I lost count of the times a client told me my quote looked broken when it was perfect on my screen. Turned out I was sending the live Excel file and it was rearranging itself on their end. Once I started sending a PDF it stopped, but honestly the spreadsheet still looked like a spreadsheet.
The Fixes That Actually Work
If you are quoting in Excel, these settings stop most of the formatting disasters. Work through them before you send.
The problem | The fix in Excel |
|---|---|
Columns cut off the edge | Page Layout, then set the Print Area around your quote, and set Width to "1 page" under Scale to Fit |
Content spills onto extra pages | Use Page Break Preview to see and drag the page breaks exactly where you want them |
Rows split across two pages | Under Page Setup, set "Rows to repeat at top" for headers, and adjust margins to keep sections together |
Layout shifts on the client's screen | Do not send the live file. Export to PDF (File, Save As or Export, PDF) so the layout is locked |
Numbers show as ###### | Widen the column, or the value is too big for the cell. Fix before exporting |
Fonts change on their computer | Stick to standard fonts like Calibri or Arial that every device has |
Gridlines make it look raw | Page Layout, untick Gridlines under View and Print, for a cleaner finished look |
The most important row in that table is the PDF one. If you take nothing else from this, take that. Never send the live Excel file to a client. Always export to PDF first. A PDF looks identical on every device and cannot be accidentally altered or rearranged, which removes almost all of the "it looked broken on my end" problems in one step.
Set Up a Print Area Once and Reuse It
A lot of the pain comes from Excel guessing what to print. Take that guess away. Select exactly the cells that make up your quote, set them as the Print Area, and fit them to one page wide. Save that as your quote template so every future quote already has the print area and scaling set correctly. You do the setup once, and every quote after that exports cleanly without the fight.
Why It Still Is Not Quite Right
Do all of the above and your Excel quotes will stop breaking. That is a real win, and worth doing. But there is a limit you will keep bumping into, and it is worth being honest about.
Even a perfectly formatted, PDF-exported Excel quote still looks like a spreadsheet. A grid of cells is a grid of cells. Next to a builder who sends a clean, branded proposal with plain-language scope and a professional layout, the spreadsheet reads as the less serious option, even when your work and your price are better. You have fixed the breaking, but you have not fixed the impression.
And you are still doing the work. Setting the print area, checking the page breaks, exporting to PDF, every single time. The formatting stops breaking, but it never stops being your job.
The Fix That Actually Lasts
Here is the thing worth understanding. Excel is brilliant at one job: building the price. Line items, quantities, rates, margins, all calculating as you work. There is no reason to give that up.
Where it falls down is being the document you send. That was never what a spreadsheet was for. So the lasting fix is not more Excel settings, it is to keep Excel for the pricing and send the quote in something built to be a client document. You price the job in the spreadsheet exactly as you do now, then present that price in a proper quote: branded, plain-language, professionally laid out, and identical on every screen because it is built to be. The formatting is handled for you, so it can never break, and the quote looks like it came from a serious business instead of a spreadsheet. This is the same split the best builders use, and it is why their quotes look professional without them fighting Excel every night.
The Bottom Line
Your Excel quotes break on the client's end because Excel reflows to their setup, not yours. You can fix most of it: set the print area, fit to one page, lock your headers, use standard fonts, and above all export to PDF instead of sending the live file. Do that and the breaking stops. But even a clean Excel quote still looks like a spreadsheet and still makes you do the formatting every time. The real fix is to keep Excel for what it is great at, the pricing, and send the quote in something built for the job.
Where Jobdocs Fits
Jobdocs is the "something built for the job." You keep pricing in Excel, then Jobdocs turns that number into a clean, branded quote or proposal where the formatting is already done and can never break, looks identical on every screen, and goes out looking like a serious business built it. No print areas, no page breaks, no exporting gymnastics. You keep the spreadsheet for the maths, and the client finally gets a document that looks right every time.
Try it free for 14 days at jobdocs.ai
