Excel does not have a built-in command that automatically sorts worksheet tabs alphabetically. You can drag tabs into order manually, or use a short VBA macro when a workbook contains many sheets.
Alphabetize a Small Number of Excel Tabs Manually
- Open the workbook.
- Review the worksheet names along the bottom of the Excel window.
- Click and drag a worksheet tab to its alphabetical position.
- Repeat for the remaining tabs.
Manual sorting is the safest choice for a workbook with only a handful of sheets because it does not require macros.
Alphabetize Many Tabs With VBA
If you are comfortable using VBA, save a backup copy of the workbook first. Macros can make broad workbook changes, and Excel may block macros from untrusted files.
- Press Alt + F11 to open the Visual Basic Editor.
- Choose Insert > Module.
- Enter a macro that compares worksheet names and moves sheets into alphabetical order.
- Run the macro only after reviewing the code and confirming that it came from a source you trust.
- Check the workbook to make sure sheet order and formulas still behave as expected.
For security, this article does not recommend lowering Excel’s macro-security settings. If macros are disabled by your organization, sort the tabs manually instead.
Things to Check Before Reordering Worksheets
Most normal formulas continue to reference the correct worksheets after tabs are moved, but workbook design can still make sheet order meaningful. Review macros, navigation instructions, charts, print workflows, and formulas that depend on positional functions before rearranging a complex workbook.
Use Consistent Names for Easier Sorting
Alphabetical order works best when sheet names follow a consistent pattern. If you need chronological order, names such as 2026-01 January, 2026-02 February, and 2026-03 March sort more predictably than month names alone.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.