Exceljet

Quick, clean, and to the point

Excel SHEET Function

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