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 travels in the file | The risk |
|---|---|
| Every formula | The margin calculation behind your price is one click away |
| Every worksheet, including hidden ones | Hiding a sheet doesn’t delete it |
| Filtered-out rows | Hiding is not removing |
| Comments and notes | Including old ones from your own drafts |
| Defined names and external links | Can point at files on your network |
| Author name and revision details | Sit in the file properties |
“Protect Sheet” in Excel doesn’t solve any of 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 is to 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 rather than just hiding them, since 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, since that’s the region that defines the page; set page breaks deliberately for long reports so sections start where you want them; and look at your headers and footers, since they carry across, including a stale “DRAFT” from three months ago.
If confidential figures are involved, lock the PDF with a password — AES-256 encryption, so only people with the password can open it, worth doing for payroll, pricing, or anything you’d rather not have forwarded around. Your name and the software that made it travel in the PDF’s metadata too, so 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.
Related reading: How to Convert Excel to PDF and What Is the Best File Format for Emailing a Document?.
Lock the numbers in place with the free Excel to PDF converter — no account required, no watermark, and nothing saved on our end.