Skip to content
ExcelExcel 2013+

SHEETS function in Excel

Returns the number of sheets in a reference

=SHEETS(reference)

SHEETS syntax and parameters

One argument, zero required.

  • referencerangeOptional

    Reference is a reference for which you want to know the number of sheets it contains. If Reference is omitted, SHEETS returns the number of sheets in the workbook that contains the function.

SHEETS examples

Formulas you'll actually reuse.

  1. How many sheets the workbook has:

    =SHEETS()

    Result6

  2. A “tab 2 of 6” label from the sheet position and count:

    ="Region " & SHEET() & " of " & SHEETS()

    Result"Region 2 of 6"

SHEETS in Google Sheets

Same name — your formula ports as-is.

Try SHEETS in the playground

Edit the example — nothing to install.

Preloaded with the SHEETS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.