Tip of the Day | August 18, 2026

This tool counts all the sheets in your active workbook and shows a detailed breakdown by sheet type.

It reports the number of:

• Worksheets
• Chart sheets
• Excel 5.0 dialog sheets
• Excel 4.0 macro sheets
• International macro sheets

At the bottom, it also shows the total number of sheets in the workbook.

• Quickly find out how many sheets are in your workbook
• Save time compared to manually counting sheets
• Audit the structure of a workbook
• Check for legacy sheet types during cleanup, migration, or upgrades

Tip:
Besides regular worksheets and chart sheets, some workbooks can also contain hidden or older sheet types, such as Excel 4.0 macro sheets. These are often invisible but can cause issues when upgrading, importing, or sharing files. This tool helps you easily find and count all sheet types.

Starting this tool