Skip to Content

SHEET

Returns the sheet number of the referenced sheet

Syntax

SHEET([value])

Parameters

  • value: Optional. The name of a sheet or a reference for which you want the sheet number. If omitted, returns the number of the sheet that contains the function

Example

=SHEET("Sheet2")
Returns: NumberSince: Excel 2013