Turn the list into a table
Make A1:H500 an Excel table with filter buttons and banded rows.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Turn A1:H500 into a table named Data
- Auto-fit the columns
Use it in MacroRoni: open the Starter gallery, search for "Turn the list into a table", 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 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