Tidy the whole workbook
On every sheet: fit the columns and freeze the top row. Then go to A1 everywhere.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Repeat on every sheet:
- Auto-fit the columns
- Freeze the top row
- End of repeat
- Go to A1 on every sheet
Use it in MacroRoni: open the Starter gallery, search for "Tidy the whole workbook", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More workbook tools macros
Workbook toolsBack up, then clean the dataSave a copy of the workbook first, then trim, remove hidden characters, empty rows and duplicates.Changes data · backup onWorkbook toolsRefresh data and saveRefresh every query and connection, then save the workbook.Doesn't change valuesWorkbook toolsComma format on every sheetShow the numbers in B2:Z1000 on every sheet as 1,234.Doesn't change values