SHEET Function
Returns the position number of a sheet.
Category
Information
Available in
Excel 2013+, Microsoft 365
Returns
A sheet number
Overview
SHEET tells you where a sheet sits in the workbook, counting tabs from the left (hidden sheets included).
Give it a reference or a sheet name in quotes, or leave it empty to get the number of the sheet the formula is on.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value | Optional | A reference (Budget!A1) or a sheet name as text ("Budget"). Omit it for the formula's own sheet. |
Examples
Example 1 — Sheet positions
A workbook with three tabs: Summary, Budget, Actuals.
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =SHEET() | 1 |
| 3 | =SHEET(Actuals!A1) | 3 |
| 4 | =SHEET("Budget") | 2 |
Example 2 — Label each month's tab automatically
With one sheet per month after a Summary tab, the sheet number gives the month.
On the second tab (January) this returns January 2026; copy the sheet and the label updates itself.
Common mistakes
- Moving tabs changes the answer. SHEET reports the current position, so dragging a tab elsewhere changes it.
- #N/A from a name. The text doesn't match any sheet name — check spelling and spaces.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.