# Excel SHEET Function

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.

**value**- [optional] The value to check.

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.