Information
SHEET Function in Excel
Returns the sheet number of the referenced sheet.
Syntax
- =SHEET([value])
Arguments
- value (optional): Sheet name or reference (default: current sheet)
Examples
- =SHEET() - Current sheet number - Result: 1
- =SHEET(Sheet3!A1) - Sheet number of Sheet3 - Result: 3
Defensive formulas with SHEET
- Use IS* functions inside IF to branch on blank, error, text, or number cells.
- Prefer [IFERROR](/functions/iferror/) when you only need a fallback display value.
- Error hub: [Fix formula errors](/guides/fix-excel-formula-errors/).
Common errors
- #N/A if sheet doesn't exist
Use cases
- Dynamic references
- Multi-sheet formulas
- Navigation
Frequently asked questions
- What is SHEET used for in Excel? SHEET returns the position number of a worksheet in the workbook. =SHEET() returns current sheet's number. =SHEET(Sheet3!A1) returns 3 if Sheet3 is the third tab. Useful for dynamic multi-sheet formulas.
- How do I use SHEET for dynamic sheet references? Combine with INDIRECT: =INDIRECT("Sheet"&SHEET()&"!A1") references A1 on current sheet. Or use SHEET to create formulas that behave differently based on which sheet they're on.
- Does SHEET count hidden sheets? Yes, SHEET counts all sheets including hidden ones. If Sheet2 is hidden, Sheet3 is still number 3. The number reflects tab order, not visible position. Use this for consistent references regardless of visibility.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.