Print-ready report
Landscape on one page wide, header repeated on every page, page numbers in the footer.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Style the header row A1:Z1
- Auto-fit the columns
- Landscape, fit to page
- Repeat row 1 on every page
- Footer: Page 1 of 3
Use it in MacroRoni: open the Starter gallery, search for "Print-ready report", 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 valuesReportsSave the sheet as a PDFFit the sheet to the page and save it as a PDF next to the workbook.Doesn't change valuesReportsExport to CSVSave the current sheet as a CSV file for other systems.Doesn't change values