MacroRoni

Starter macros › Reports

Clean dashboard look

Hide gridlines, style the header, use a modern font and zoom out a little.

Formats, highlights or saves files. Doesn't change your values.

What it does, step by step

  1. Hide gridlines
  2. Style the header row A1:Z1
  3. Use Segoe UI in A1:Z500
  4. Auto-fit the columns
  5. Zoom to 90%

Use it in MacroRoni: open the Starter gallery, search for "Clean dashboard look", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

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 valuesReportsSave the sheet as a PDFFit the sheet to the page and save it as a PDF next to the workbook.Doesn't change values