Tip of the Day | Wednesday December 24th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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.

Screenshots

Info & List › Count All Worksheets, Chart Sheets, and Macro Sheets

Starting this tool

Click ASAP Utilities › Info & List › 16. Count All Worksheets, Chart Sheets, and Macro Sheets
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.