List every sheet
Write the name of every worksheet down column A, under a bold heading.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “Sheets” in A1
- Bold A1
- List the sheet names from A2
Use it in MacroRoni: open the Starter gallery, search for "List every sheet", 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 & safetyFormat every sheet the sameStyle the header, freeze the top row and fit columns on every sheet in the workbook.Doesn't change valuesSheets & safetyLock the finished sheetAsk first, then replace formulas with their results and protect the sheet from edits.Changes data · backup on