Excel SHEET Function

Summary

The Excel SHEET function returns the index number of a sheet in Excel. It will report the sheet number for a cell reference, named range, or Excel Table.

Purpose

Get sheet index number

Return value

The index number of a given sheet

Syntax

=SHEET ([value])

Arguments

value - [optional] The value to check.

Usage notes

Use the SHEET function to get the index number for a given sheet. The index number represents the numeric sequence of sheets in an Excel workbook, starting with 1 on the left and ending with N on the left, where N is the total number of sheets in the workbook. The SHEET function includes hidden sheets in the numbering sequence.

For example, in a workbook with Sheet1, Sheet2, and Sheet3 running left to right, the following formula will return 2:

=SHEET(Sheet2!A1)

If Sheet2 is dragged all the way to the left, the formula above will return 1.

Notes

If the value argument is omitted, SHEET will return the index of the sheet it's entered on.
Typically, value is supplied as a cell reference, but you can also supply a named range or the name of an Excel Table
The SHEET function includes hidden sheets in the numbering sequence.
SHEET reports the index of a sheet, the SHEETS function reports the number of sheets in a reference