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

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.