Syntax
SHEETS([reference])
| Parameter | Description |
|---|---|
| [reference] | (Optional.) Parameter of the SHEETS function. |
Examples
Count all sheets
Formula
=SHEETS()
Returns the total number of sheets in the workbook. If your workbook has 5 tabs, returns 5.
Workbook info display
Formula
="This workbook has " & SHEETS() & " sheets"
Creates a descriptive string like "This workbook has 12 sheets" for a documentation or summary page.
Common Errors
#REF!
Occurs if the 3D reference includes deleted sheets.
Tips
No argument = all sheets
=SHEETS() with no argument counts every sheet in the workbook, including hidden sheets.
Includes hidden sheets
SHEETS counts all sheets regardless of visibility. If you have 3 visible and 2 hidden sheets, SHEETS() returns 5.
Combine with SHEET
=SHEET() & " of " & SHEETS() gives you "3 of 12" style navigation text — useful for multi-sheet report templates.
Try SHEETS in Viztab
Import your data and use SHEETS with 370+ other formulas. No signup required.
Open Viztab