logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Count All Worksheets, Chart Sheets, and Macro Sheets

ASAP Utilities  › Info & List  ›  16. 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  ›  16 Count All Worksheets, Chart Sheets, and Macro Sheets

    Starting this tool


    Info & List  ›  16 Count All Worksheets, Chart Sheets, and Macro Sheets
    Additional keywords for 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



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