Sort sheet tabs A to Z
Put the worksheet tabs in alphabetical order.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Sort the sheet tabs A to Z
Use it in MacroRoni: open the Starter gallery, search for "Sort sheet tabs A to Z", 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