ysskrishna logoysskrishna

Chapter 6 of 6 · 4 min

Recipe: a 10-minute monthly tab clean-up

A routine for workbooks that grow every month: back up, unhide, delete scratch, archive, rename, colour, sort.

Run this on the first working day of each month, on any workbook that gains tabs over time.

The routine

  1. Back up. File → Make a copy, or note the time so you can find it in version history.
  2. Unhide everything. Sidebar → tick all HIDDEN tabs → Unhide. Nothing escapes review.
  3. Delete scratch tabs. Search Copy of, then Sheet. Tick the ones you don't need. Delete, read the dialog, confirm. Check for #REF! errors afterwards (chapter 2).
  4. Archive last month's working tabs. Tick them → Rename with prefix ARCHIVE - → Color grey → Hide.
  5. Fix names. Search for anything that breaks your convention; Rename with find and replace.
  6. Colour new tabs by your scheme (chapter 5).
  7. Sort A → Z if your names are designed for it.
  8. Leave the summary active: click the summary tab so it is what people see first.

When to split the file instead

If the archive keeps growing, move archived tabs into a separate "Archive 2025" spreadsheet: in each tab, right-click → Copy to → Existing spreadsheet, then delete it from the live file. Big workbooks load and recalculate more slowly, and a lean live file is easier to share.

Checklist to copy into your README tab

Monthly tab clean-up
[ ] Backup / note time
[ ] Unhide all, review
[ ] Delete scratch (Copy of…, SheetN), check #REF!
[ ] Archive last month: prefix "ARCHIVE - ", grey, hide
[ ] Rename to convention
[ ] Colour new tabs
[ ] Sort A→Z
[ ] Summary tab active

A worked month-end

Here is the routine applied to a real-looking file at the start of a month. Before:

TabAction this month
0 READMEUpdate "last tidied" date
2026-10 SalesKeep visible (current)
2026-09 SalesHide
2026-08 SalesAlready hidden; leave
Copy of 2026-10 SalesCheck references, then delete
Sheet12Check, then delete
9 ListsLeave hidden

Steps in the sidebar, roughly five minutes:

  1. Click Refresh so the list matches the file.
  2. Search Copy of, then Sheet, ticking the scratch tabs. Search formulas for their names (Edit → Find and replace), then Delete and read the dialog list.
  3. Search 2026-09, tick it, click Hide.
  4. Add the new month: duplicate the current tab in Sheets, then use Rename to change Copy of 2026-10 Sales to 2026-11 Sales.
  5. Click Sort (A → Z) so the new month lands in order.
  6. Update the README tab.

Make it a habit

The routine is short because it runs every month. Put a recurring reminder on your calendar for the first working day of the month, and keep the checklist on the README tab so anyone covering for you can run it. If the routine starts taking longer than ten minutes, that is a sign the file is doing too much; see "When to split the file instead" above.

What you learned in this course

You can now find tabs quickly with search, delete in bulk without breaking formulas, hide and unhide sets of tabs, rename with find and replace, and use colour, names and sorting together so a large file stays navigable. Each action works on a selection, so the habit that ties them together is the same: search, tick, read what will happen, then apply.

Troubleshooting

SymptomLikely causeFix
The sidebar list does not show a tab you just addedThe list was loaded before the changeClick Refresh
#REF! errors appear after the clean-upA deleted tab was still referencedUndo, or copy the tab back from version history, then repoint the formula
A colleague says "the Sept tab is gone"It was hidden, not deletedUnhide it from the sidebar, or point them to View → Hidden sheets
Sort put README in the middleIts name does not sort firstRename it 0 README, then sort again
Delete is refusedYou selected every visible tabLeave at least one tab unselected

Most of these are avoided by reading the confirmation dialog and the preview before applying, which is the habit the whole course is built around.

Quick check

  1. Why unhide everything first?So hidden tabs are reviewed too, and nothing is deleted or kept by accident.

  2. What three actions archive a tab in this routine?Prefix "ARCHIVE - ", colour grey, hide.

  3. When should archived tabs move to another file?When the archive makes the live workbook slow or hard to share.

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