Make a report look professional
Dark header row, banded rows, borders, frozen header and fitted columns.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Style the header row A1:Z1
- Shade every other row
- Thin borders around A1:Z1000
- Freeze the top row
- Auto-fit the columns
Use it in MacroRoni: open the Starter gallery, search for "Make a report look professional", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More reports macros
ReportsPrint-ready reportLandscape on one page wide, header repeated on every page, page numbers in the footer.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