Tip of the Day | Wednesday 1 July 2026

This tool creates a list of all worksheet names in your current workbook.

It generates a new workbook with a simple report showing the names of each sheet, one per row. This helps you quickly review or document the structure of your workbook.

Use it to:

• Get a quick overview of all sheet names
• Document or audit your workbook layout
• Spot missing, extra, or default-named sheets (like "Sheet1", "Sheet2")

Tip:
You might also be interested in the "Create an Index Page (TOC) with Clickable Links to All Sheets..." tool, which inserts a clickable table of contents in your workbook.

Starting this tool