logo ASAP Utilities

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


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

    Choose your language preference below

    English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 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.