Colour and order make a big workbook readable. A reader sees the green tabs are outputs and the grey ones are inputs, and finds a month without scrolling.
Colour many tabs
- Tick the tabs in one group.
- Click Color. The Choose Tab Color dialog shows a grid of swatches.
- Click a swatch. The colour applies to every selected tab.
- Reset Color removes the colour from the selected tabs; Cancel closes without changes.
A colour scheme that works
| Colour | Meaning |
|---|---|
| Green | Outputs people read (summary, dashboard) |
| Blue | Inputs people edit (forms, assumptions) |
| Grey / none | Raw data and imports |
| Orange | Calculations, don't edit |
| Red | Deprecated, to be deleted |
Write the scheme on a README tab. Colour is only useful if everyone reads it the same way.
Sort tabs
Click Sort and choose:
- A → Z (Ascending)
- Z → A (Descending)
Sorting reorders the tab bar alphabetically.
Make alphabetical order useful
Alphabetical order is only meaningful if names are designed for it:
2026-01 Sales,2026-02 Salessort chronologically;Jan Sales,Feb Salesdo not.- Prefixes group tabs:
00 README,10 Inputs,20 Calc,30 Output. Numbers in prefixes are a simple way to force an order that is not alphabetical. - Sorting moves your summary tab too. If it must stay first, give it a prefix like
00.
Step by step
- Rename tabs with prefixes (chapter 4):
00 README,10 Inputs,20 Calc,30 Summary. - Click Sort → A → Z (Ascending). Check the order matches the numbers.
- Search
10, tick the input tabs, Color → blue. - Search
30, tick, Color → green.
Practice: colour by status, then sort
Use a copy of a file with at least eight tabs.
- Search for your input tabs (for example
RaworImport), tick them all, click Color, and pick one colour from Choose Tab Color. - Search for report tabs, tick them, and give them a second colour.
- Leave reference and lookup tabs uncoloured, or use a third, neutral colour.
- Click Sort, choose A → Z (Ascending), and look at the result.
Notice what sorting did to your colour groups: tabs are ordered by name, not colour, so inputs and reports are now interleaved. If you want colour groups to sit together, the names have to carry the group, which is the point of the next section.
Names that sort into groups
A short prefix per group makes alphabetical order match the colour scheme:
| Prefix | Colour | Example tabs |
|---|---|---|
0 | Dark | 0 README, 0 Dashboard |
1 | Blue | 1 Raw orders, 1 Raw refunds |
2 | Green | 2 Monthly report, 2 Weekly report |
9 | Grey | 9 Lists, 9 Archive 2025 |
With these prefixes, A → Z puts README and Dashboard first and the archive last, and every colour forms one block. Add the prefixes in one go with bulk rename (chapter 4).
When to reset colours
Reset Color removes the colour from the selected tabs. Use it when a status has ended, for example after a monthly close, so colour keeps meaning "needs attention" instead of becoming decoration. A file where every tab is coloured tells the reader nothing.
Common mistakes
- Using more than four colours. Readers cannot remember what eight colours mean; keep a legend on the README tab if you need more.
- Relying on colour alone. Some readers cannot tell red from green; the prefix or the name should carry the same information.
Sorting caveats
Sorting reorders the tabs in the file, so a tab you deliberately placed first (a README or a dashboard) moves unless its name sorts first. Sort is also a one-shot action: new tabs added later appear wherever Sheets puts them, usually next to the active tab, so re-run the sort as part of the monthly routine. And because readers often navigate by position ("the third tab"), tell collaborators before you re-sort a shared file.
Quick check
-
How do you remove colour from several tabs?Select them, Color → Reset Color.
-
"Jan, Feb, Mar" sort as Feb, Jan, Mar. How do you fix it for good?Rename with sortable dates such as 2026-01, or number prefixes.
-
How do you keep a README tab first after sorting?Give it a prefix that sorts first, such as
00.






