See all How-To Articles

How to Count Number of Worksheets in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 14, 2023

This tutorial demonstrates how to count the number of worksheets in an Excel file.

 

count worksheets 3

 

Count Number of Worksheets

The easiest way to count the number of worksheets in your workbook is to use the SHEETS Function. Say your Excel file has six worksheets.

 

count worksheets 1

 

In any cell on any of the sheets, enter the formula:

=SHEETS()

 

count worksheets 2

 

As you can see, this function without arguments returns the total number of sheets in the current workbook (including hidden sheets).

Tips:

See all How-To Articles