SHEET Function

Returns the position number of a sheet.

Category

Information

Available in

Excel 2013+, Microsoft 365

Returns

A sheet number

Want to practice SHEET in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=SHEET([value])

Arguments

ArgumentRequired?What it does
valueOptionalA 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.

AB
1FormulaResult
2=SHEET()1
3=SHEET(Actuals!A1)3
4=SHEET("Budget")2
Formulas typed on the Summary sheet.

Example 2 — Label each month's tab automatically

With one sheet per month after a Summary tab, the sheet number gives the month.

=TEXT(DATE(2026,SHEET()-1,1),"mmmm yyyy") Explain

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

Kyle Stott

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.