Count All Worksheets, Chart Sheets, and Macro Sheets

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

Additional keywords to help you find this tool:
count sheets workbook, count worksheets Excel, count sheets Excel, count chart sheets, count macro sheets, total sheets in workbook, Excel sheet counter, sheet types in workbook, Excel count sheets tool, audit workbook sheets, check number of sheets Excel, find legacy sheets Excel

Tip:Alt+P for the previous tool.