Save the sheet as a PDF
Fit the sheet to the page and save it as a PDF next to the workbook.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Auto-fit the columns
- Landscape, fit to page
- Save as Report.pdf
Use it in MacroRoni: open the Starter gallery, search for "Save the sheet as a PDF", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More reports macros
ReportsMake a report look professionalDark header row, banded rows, borders, frozen header and fitted columns.Doesn't change valuesReportsPrint-ready reportLandscape on one page wide, header repeated on every page, page numbers in the footer.Doesn't change valuesReportsExport to CSVSave the current sheet as a CSV file for other systems.Doesn't change values