The Recurring Report Workflow
If you send the same type of report every month (sales, expenses, KPIs, project status), you shouldn't be re-configuring your print settings each time. Here's the efficient workflow:
- 1.Set it up once. Configure your print area, orientation, margins, scaling, and headers/footers in your Excel template. Save the file.
- 2.Update data monthly. Each month, open the template, update the numbers, and save. All your print settings are preserved.
- 3.Convert to PDF. Upload to OmnisPDF's Excel to PDF tool. The converter respects your saved print settings.
- 4.Compress and send. If the PDF is over the email limit, compress it before attaching.
Setting Up Your Print Area (Do This Once)
Select your report range
Click the first cell of your report (usually A1) and drag to the last cell with data. If your report has a title row and a totals row, include both. Don't include scratch columns or helper rows used for calculations.
Set the print area
Go to Page Layout → Print Area → Set Print Area. A dotted line appears around your selected range. This is now the only data that will appear in the PDF — everything outside is excluded.
Configure page settings
Set Orientation to Landscape (for wide reports) or Portrait (for narrow ones). Set Margins to Narrow. Set Scale to Fit → Width: 1 page. These settings save with the file.
Professional Presentation Tips
A well-formatted PDF report looks more professional than a raw Excel file. Here's how to make your reports stand out:
Add Headers and Footers
Go to Insert → Header & Footer in Excel. Add your company name in the header, and the date plus page numbers in the footer. These appear on every page of the PDF, giving it a polished, professional look.
Include a Report Title Row
Make row 1 a title row with the report name and date range (e.g., "Monthly Sales Report — February 2026"). Use a larger font size and bold formatting. This makes the PDF self-explanatory when someone opens it months later.
Use Consistent Formatting
Apply number formatting to all data cells (currency, percentages, dates). Use alternating row colors for readability. Bold your totals row. These details convert cleanly to PDF and make the report easier to scan.
Freeze the Column Headers
In Excel, go to Page Layout → Print Titles → Rows to repeat at top and select your header row. This prints the column headers at the top of every page in the PDF — essential for multi-page reports.
Compressing Your Report for Email
Most email providers cap attachments at 20-25MB. If your report PDF is larger (common with charts or images), compress it before sending:
- ✓ Use Compress PDF for Email — optimized specifically for email attachment limits
- ✓ Medium compression keeps charts and tables readable while significantly reducing file size
- ✓ A typical 5MB report with charts compresses to 1-2MB — well under the email limit
For very large reports, consider splitting the PDF into sections using Split PDF and sending as multiple attachments.
Protecting Sensitive Financial Reports
Financial reports often contain sensitive data — revenue numbers, salary information, profit margins. Before emailing these, consider adding protection:
- ✓ Password protection — Use Protect PDF to add a password. Share the password separately (text message, phone call, or a different email).
- ✓ Read-only access — Restrict editing permissions so recipients can view but not modify the PDF.
- ✓ Watermarking — Add a "Confidential" watermark to mark the document's sensitivity level.
Combining Multiple Reports Into One PDF
Need to send a quarterly package with three monthly reports? Convert each Excel file to PDF separately, then use Merge PDF to combine them into a single document. You can also add a cover page or a table of contents as the first page. This creates a professional, consolidated package that's easier for recipients to manage than multiple attachments.