Format every sheet the same
Style the header, freeze the top row and fit columns on every sheet in the workbook.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Repeat on every sheet:
- Style the header row A1:Z1
- Freeze the top row
- Auto-fit the columns
- End of repeat
Use it in MacroRoni: open the Starter gallery, search for "Format every sheet the same", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More sheets & safety macros
Sheets & safetySave a backup copySave a dated copy of the workbook before you make big changes.Doesn't change valuesSheets & safetyLock the finished sheetAsk first, then replace formulas with their results and protect the sheet from edits.Changes data · backup onSheets & safetyShow everything that is hiddenUnhide every sheet, plus the hidden rows and columns on this sheet.Doesn't change values