You finish a quote, a budget, or a report in Excel and email the workbook. Three things can now go wrong: someone changes a number and forwards it as yours, someone clicks a cell and reads the formula behind it, or someone finds the hidden sheet with your cost basis on it.
What’s actually inside the file you sent
A workbook carries far more than the grid you were looking at:
- Every formula, including the margin calculation behind your price
- Every worksheet, including the ones you hid rather than deleted
- Filtered-out rows — hiding is not removing
- Comments and notes, including old ones from your own drafts
- Defined names and external links pointing at files on your network
- The author name and revision details in the file properties
“Protect Sheet” in Excel doesn’t solve this. It stops casual editing with a password that’s trivially removed, and it doesn’t hide anything from someone who knows where to look.
The straightforward fix: send a PDF
Convert the Excel file to PDF and what you send is exactly what you saw: values, formatting, borders, and number formats, with no formulas, no hidden sheets, and no filtered rows underneath. It opens on any device without Excel installed and it looks the same on every one of them.
Every worksheet in the workbook is included, and each sheet is scaled to fit one page wide — which also fixes the classic problem of a wide report spilling its last three columns onto a page of their own.
Prepare the workbook first
The conversion is faithful, so tidy up before rather than after:
- Delete the sheets you don’t want to send, don’t just hide them — hidden sheets are still included as pages.
- Clear filters so you can see exactly what will be rendered.
- Check the print area if you’ve set one; that’s the region that defines the page.
- Set page breaks deliberately for long reports so sections start where you want them.
- Look at your headers and footers — they carry across, including a stale “DRAFT” from three months ago.
When you need more than a PDF
- Confidential figures? Lock the PDF with a password. It’s encrypted with AES-256, so only people with the password can open it — worth doing for payroll, pricing, or anything you’d rather not have forwarded around.
- Scrub the document properties. Your name and the software that made it travel in the PDF’s metadata. View and clear it before sending externally.
- Combining it with other documents? Merge the PDFs into one attachment rather than sending five files.
- Too big for email? Compress it.
They need to work with the numbers after all
Sometimes the recipient genuinely does need the data — a client wants to model their own scenarios, or a colleague needs to extend the analysis. In that case send the workbook, but send a copy you’ve cleaned: delete unused sheets, clear the comments, and remove the formulas you don’t want read by pasting values only.
And if someone sends you a PDF report and you need the figures out of it, PDF to Excel pulls the tables back into real rows and columns.
Ready? Try the free Excel to PDF converter now — no sign-up, no watermark, and your file is never stored.