Summary
SHEET returns the index number of a sheet. If you leave the argument out, it returns the position of the sheet where the formula lives.
This is useful when tab order matters. Some workbooks rely on a fixed sheet sequence, and SHEET gives you a simple way to test or display that order.
Purpose
Gives the numeric position of a sheet in the workbook.
Return Value
The result is the sheet index, where 1 means the leftmost sheet.
Syntax
=SHEET([value])The argument is optional. You can omit it, use a sheet name, or use a reference that points to a sheet.
Arguments
- value - [optional] A sheet name or a reference on the sheet you want to identify.
SHEET vs SHEETS
| Function | Main job | Use it when |
|---|---|---|
SHEET |
Returns one sheet position | You want to know where a sheet sits in the workbook order. |
SHEETS |
Returns a sheet count | You want the number of sheets in a workbook or reference. |
CELL |
Returns info about a cell | You need address-style details instead of a sheet index. |
ISREF |
Checks whether something is a reference | You want to validate a reference before working with it. |
Using SHEET
This function is helpful in navigation helpers, workbook audits, and templates that depend on a fixed tab sequence. For example, you can show the current sheet index on the sheet itself or test whether a specific sheet is in the expected position.
Microsoft notes that the argument can be omitted. When you do that, SHEET() returns the index of the current sheet. When you pass a sheet name or reference, it returns the index for that target instead.
Example 1 - Get the current sheet index
This is the simplest use.
=SHEET()Return the index of the current sheet. Formula: =SHEET().
Example 2 - Get the index of a named sheet
Use a sheet name when you want the position of a specific tab.
=SHEET("Summary")Return the index of a named sheet. Formula: =SHEET("Summary").
Example 3 - Use a reference instead
A reference works too, as long as it points to the sheet you care about.
=SHEET(Sheet1!A1)Return the index of the sheet behind a reference. Formula: =SHEET(Sheet1!A1).
Example 4 - Test whether the current tab is first
This is a simple sequence check.
=SHEET()=1Check whether the current sheet is the first tab. Formula: =SHEET()=1.
Conclusion Recap
- Main job:
SHEETreturns one sheet index. - No argument: It returns the current sheet position.
- With an argument: It returns the position of the referenced or named sheet.
- Good use: Workbook order checks and navigation helpers.
Tell your friends about this post