How to sort tabs alphabetically in Google Sheets
By Jake Marsh · Updated
Google Sheets can't sort tabs by name; you can only drag them one at a time. To sort tabs alphabetically, open Extensions, Tabherd, Open Tabherd, choose Sort, pick A to Z (Week 2 before Week 10) under Order, click Preview, then Apply. Leave every tab unticked to sort the whole spreadsheet, or tick some tabs to sort only those.
Pick the order
| Order | Good for |
|---|---|
| A to Z (Week 2 before Week 10) | Names with numbers: Week 2 comes before Week 10, Unit 9 before Unit 11 |
| A to Z, plain text order | Strict character order, where "Week 10" comes before "Week 2" |
| Z to A (numbers in order), Z to A, plain text order | Newest-first when names end in a year or number |
| By tab color | Grouping tabs you've colored by status or team |
| Hidden tabs last | Pushing hidden tabs to the end of the bar |
| Reverse current order | Flipping a list that's in the wrong direction |
| Custom: drag tabs in the list | Your own order, set in the sidebar |
Steps
- Open Tabherd from the Extensions menu.
- Tick the tabs to sort, or tick none to sort all of them.
- Choose Sort and an Order.
- Click Preview. Each tab is listed with its position before and after.
- Click Apply.
Sorting only part of the tab bar
A workbook often starts with a few tabs that should stay first, such as Summary, Instructions or Dashboard, followed by many tabs that should be in order. Tick only the tabs to sort. They're sorted within the places they already hold, and the unticked tabs stay exactly where they are. Use the search box to tick a set quickly, such as every tab with "2026" in its name.
Putting tabs in the order you want
For an order no rule describes, choose Custom: drag tabs in the list and drag the tabs in the sidebar, which is quicker than dragging them along the tab bar of a large file. To send a few tabs to one end, use Move: To the start, To the end or Right after a tab.
Undo a sort
Every sort goes into History with an Undo button, which puts the tabs back in the order they were in.
What it costs
Tabherd is $2.99 a month or $19 a year per Google account. Free trial: 30 days or 60 applied changes, whichever comes first. No card needed. Every plan and the install link are on the Tabherd page.
Tabherd: Bulk Tab Manager for Sheets
Hide, sort, rename, protect and copy many Google Sheets tabs at once, with a preview and undo for every change $2.99 a month or $19 a year per Google account.
Questions
Why does Week 10 come before Week 2 when I sort?
Plain text order compares one character at a time, and "1" comes before "2". A to Z (Week 2 before Week 10) reads the numbers as numbers.
Does sorting tabs change my formulas?
No. Formulas refer to tabs by name, so moving tabs doesn't break them.
Can I sort tabs by date?
If the names hold dates in a sortable form, such as 2026-01 or 2026-02, A to Z puts them in date order. Names like "Jan" and "Feb" need Custom order, or a rename to a numbered pattern first.
Do hidden tabs get sorted too?
Yes, if they're ticked or you sort every tab. Tabherd keeps them hidden while it moves them.
More Tabherd guides
- How to make a copy of a template tab for each name in a list
- How to unhide all sheets in Google Sheets at once
More Google guides
- How to compare two Google Sheets for differences (Tabmeld)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to move GA4 Reports Builder reports to Trafficledger (Trafficledger)
- How to show dotted-line reporting on an org chart from Google Sheets (Rowtree)