SHEET Function Explained

The SHEET function in Microsoft Excel returns the sheet number for a given reference. It takes a single argument, which is a reference to a cell or range of cells in an Excel worksheet. The function returns the sheet number of the worksheet that contains the reference.

SHEET Function Syntax

SHEET(value)

  • value: The value argument is a reference to a cell or range of cells. It can be a number, text, or logical value that you want to look up in a reference or array.