SHEET Function

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.

SHEET is useful in workbooks where sheet identity carries meaning. It can help with navigation logic, audits, or formulas that need to react to workbook structure, especially when the model spans multiple tabs and the sheet number itself becomes part of the check.

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

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 example leaves the argument empty, so Excel returns the index number of the current worksheet. In other words, it tells you where the active tab sits in the workbook order.

That can be useful in workbook checks or small navigation formulas where the sheet position itself matters. The result changes depending on which sheet the formula is on.

=SHEET()

Example 2 - Get the index of a named sheet

Here the function is pointed at a named sheet instead of the current one. The result is the position number of that sheet inside the workbook tab order.

This is helpful when you want to compare sheet positions or confirm that a required tab exists where you expect it in the workbook structure.

=SHEET("Summary")

Example 3 - Use a reference instead

This example shows that SHEET can use a real cell reference, not just a quoted sheet name. Excel reads the reference and returns the index of the sheet it belongs to.

That makes the function more flexible when your formula already uses references and you do not want to type sheet names separately.

=SHEET(Sheet1!A1)

Example 4 - Test whether the current tab is first

In this version, the sheet index is being used inside a logical test. The formula checks whether the current worksheet is the first tab in the workbook.

That kind of check can be useful in templates or workbook rules where certain logic should only run on one specific sheet position.

=SHEET()=1

Conclusion Recap

SHEET is a simple workbook-order function. In this lesson, it was used to get the number of the current tab, check the position of another sheet, and test whether the workbook still follows the tab order you expect.

The main rule is easy to remember. Leave it empty to get the current sheet number, or give it a sheet name or reference when you want the number for a different sheet.

• Main job: SHEET returns 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.