Excel 2013+
Information
The Excel SHEET function returns the index number of a worksheet — its position in the tab order — useful for navigation formulas and dynamic references across many sheets.
Quick answer: which sheet number am I on?
=SHEET() // position of the current sheet
Syntax
=SHEET([value])
| Argument | Description | |
|---|---|---|
value | Optional | A sheet name or reference; omitted = the sheet containing the formula. |
How to use it
SHEET returns the tab position (1 for the first tab, 2 for the second…), counting hidden sheets too. Pass a name to find a specific sheet’s index: =SHEET("Summary"). For the total count, use SHEETS.
Try it: interactive demo
Live demo
Pick an input and watch the formula and result update.
This function takes no inputs to vary — here is what it returns:
Result:
Practice workbook
Download the free SHEET practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.
Frequently asked questions
Does SHEET count hidden sheets?
Yes — the index reflects every tab, hidden or visible.
SHEET vs SHEETS?
SHEET returns one sheet’s position; SHEETS returns the total number of sheets in a workbook or reference.
How do I get the sheet NAME?
SHEET gives the number; for the name use CELL("filename") parsing or the newer TEXTAFTER approach.
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class