SHEET in Excel: Sheet Position, Names and Structural Changes

=SHEET([value])

The optional argument can specify a sheet name or a reference whose sheet number is needed. A quoted sheet name is text such as “Report”; a direct reference is written as Report!A1 for a simple sheet name.

Microsoft says the numbering includes visible, hidden and very hidden worksheets, plus other sheet types such as chart sheets. Do not infer a position solely by counting the visible worksheet tabs.

For these structural expectations, create a disposable workbook containing exactly three worksheets in this order: Intro, Input, Report. Use those exact names and no extra sheets. The expected positions are 1, 2 and 3.

These are independently modeled workbook-layout expectations, not results captured from native Excel. The result in an existing workbook will depend on that workbook’s actual structure.

On Report, compare:

=SHEET()
=SHEET("Input")
=SHEET(Input!A1)

Expected results are 3, 2 and 2 in the specified layout. The first inspects the formula’s own sheet; the others identify Input by name or reference.

The value stored in Input!A1 does not need to equal its sheet number. The argument’s reference identifies the containing sheet; this is a structural query, not a request to read A1’s numeric value as an index.

In a separate copy of the fixture, move Report ahead of Intro so the order becomes Report, Intro, Input. SHEET() on Report now has expected 1, while SHEET(“Input”) has expected 3.

The sheet identities remained the same, but their ordinal positions changed. A formula using a position as a permanent business identifier can therefore become misleading after an ordinary layout edit.

A direct reference such as SHEET(Input!A1) expresses a relationship to a worksheet reference. A quoted string such as “Input” is a literal name. If a sheet is renamed, verify formulas that contain its old name as text rather than assuming the text was updated like a normal reference.

For a name containing spaces, a reference uses single quotes around the sheet name, such as SHEET('Data Entry'!A1). A text-name call uses double quotes: SHEET("Data Entry"). These are different syntactic roles.

In the original three-sheet setup, =SHEET("Input") has expected 2, while =SHEETS() has expected 3. SHEET returns a position; SHEETS returns a count.

Hiding Input does not remove it from the scope Microsoft documents for numbering. The visible-tab count would no longer describe all counted sheets. This guide does not instruct readers to expose or alter hidden sheets in an important workbook merely to inspect a formula.

The dedicated reference documents #REF! for an invalid reference. It also documents an error for a nonexistent sheet-name string, labeling it #NA in the help text. No missing-name error was captured natively here; do not confuse that case with a valid sheet whose number happens to differ from an expected position.

Microsoft’s example also shows #NAME? when a supplied defined name is unavailable in the formula’s scope. Check whether a name is workbook-scoped or sheet-scoped and whether it actually points to a reference.

If a result shifts after an edit, inspect the sheet order and all included sheet types. If a name-based formula fails after renaming, inspect literal text names. If the intended question is “how many sheets,” use the separate SHEETS function.

The reference says SHEET is not an Object Model member because similar capabilities already exist there; that note is not a statement that the worksheet function is unavailable. Native renaming behavior, recalculation timing, external references and every special sheet type were not executed here.

• Current documentation: the dedicated Microsoft reference lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Introduced: Microsoft’s alphabetical catalog marks SHEET as introduced in Excel 2013. Exact first build and platform-specific introduction dates remain unverified.
• Last functioning version: unknown; a current help listing is not a last-working-build test.
• Evidence checked: October 15, 2026. Official documentation was freshly retrieved; examples were independently calculated. No native Excel, Mac or web-client execution was performed.

• Microsoft SHEET reference.
• Microsoft function catalog and introduction-marker explanation.
• Editorial testing standards.

Examples use English function names and comma separators. Expected numbers are rounded independent mathematical calculations; documented error expectations are labeled as such. They are not captured Excel output. All illustrative data and policies are fictional.