SHEET function
SHEET returns the position number of a sheet in the workbook, counting from the first tab. Hidden sheets still count toward the position, and the result is a single sheet number.
Example
Read it as a sentence: give the number of the sheet that holds cell B1 on the Items sheet, which gives 3.
Excel shows 3
B
1
Item
Items
Syntax
SHEET([value])
Arguments in [square brackets] are optional.
-
value(optional) - A sheet name or reference; omit for the current sheet.
Returns: The sheet number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SHEET() | 6 | Own sheet |
=SHEET("Data") | 1 | Sheet name text |
=SHEET("data") | 1 | Lower-case name |
=SHEET(Items!B1) | 3 | Reference |
=SHEET("Nope") | #N/A | Missing sheet |
=SHEET(5) | #N/A | Number |
The Items sheet these formulas read
B
1
Item
Items
Watch out for
- Hidden sheets still count.
Where it works
- Excel
- SHEET arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use. Added to Sheets later; check your edition.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .