ysskrishna logoysskrishna

Chapter 5 of 6 · 4 min

Colour-code and sort tabs

Give groups of tabs one colour, reset colours, and sort the whole tab bar A → Z or Z → A.

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

  1. Tick the tabs in one group.
  2. Click Color. The Choose Tab Color dialog shows a grid of swatches.
  3. Click a swatch. The colour applies to every selected tab.
  4. Reset Color removes the colour from the selected tabs; Cancel closes without changes.

A colour scheme that works

ColourMeaning
GreenOutputs people read (summary, dashboard)
BlueInputs people edit (forms, assumptions)
Grey / noneRaw data and imports
OrangeCalculations, don't edit
RedDeprecated, 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 Sales sort chronologically; Jan Sales, Feb Sales do 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

  1. Rename tabs with prefixes (chapter 4): 00 README, 10 Inputs, 20 Calc, 30 Summary.
  2. Click Sort → A → Z (Ascending). Check the order matches the numbers.
  3. Search 10, tick the input tabs, Color → blue.
  4. Search 30, tick, Color → green.

Practice: colour by status, then sort

Use a copy of a file with at least eight tabs.

  1. Search for your input tabs (for example Raw or Import), tick them all, click Color, and pick one colour from Choose Tab Color.
  2. Search for report tabs, tick them, and give them a second colour.
  3. Leave reference and lookup tabs uncoloured, or use a third, neutral colour.
  4. 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:

PrefixColourExample tabs
0Dark0 README, 0 Dashboard
1Blue1 Raw orders, 1 Raw refunds
2Green2 Monthly report, 2 Weekly report
9Grey9 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

  1. How do you remove colour from several tabs?Select them, Color → Reset Color.

  2. "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.

  3. How do you keep a README tab first after sorting?Give it a prefix that sorts first, such as 00.

Continue exploring

ProductGoogle WorkspaceGoogle Sheets Tab Manager

Google Sheets Tab Manager

Your workbook outgrew the tab bar. Clean it up in batches.
Google Sheets Tab Manager
Google Workspace Add-ons
Google Sheets
Google Apps Script
BlogCover image for How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

How to Delete Multiple Tabs in Google Sheets at Once (Bulk Hide, Rename, Sort)

Google Sheets Tab Manager
Google Workspace Add-ons
+1
2 min read
ProductGoogle WorkspaceGoogle Sheets Merge Tools

Google Sheets Merge Tools

Repeatable merges in Google Sheets, without the misclick marathon.
Google Sheets Merge Tools
Google Workspace Add-ons
Google Sheets
Google Apps Script
CourseCover image for Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Table Converter for Google Sheets: Import and Export Markdown, JSON, HTML and CSV

Import Markdown, JSON, HTML and CSV tables into Google Sheets without broken columns, and export any range as clean Markdown, JSON, HTML or CSV.

Google Sheets Table Converter
Google Sheets
+1

6 chapters · 16 min

ProductGoogle WorkspaceGoogle Sheets Text Power Tools

Google Sheets Text Power Tools

Fix messy sheet text in place. Case, trim, strip, and extract without leaving the grid.
Google Sheets Text Power Tools
Text & Data Conversion
Google Workspace Add-ons
Google Sheets
ProductGoogle WorkspaceGoogle Sheets Table Converter

Google Sheets Table Converter

Pipe tables, JSON, CSV, or HTML in and out of Sheets, without leaving the grid you are already in.
Google Sheets Table Converter
Markdown & Docs
Text & Data Conversion
Google Workspace Add-ons