Author: Oscar Cronquist Article last updated on May 04, 2018

The SHEET function returns the sheet number of the cell reference sheet.

Formula in cell D3:

=SHEET(A1)

Excel Function Syntax

SHEET(value)

Arguments

value Optional. Value is a cell reference for which you want the sheet number. SHEET function returns the number of the sheet that contains the function if value is omitted,