SHEET

Formulas / SHEET
Return the sheet number for a reference sheet.
=SHEETS([reference])
  • [reference] - [OPTIONAL] A reference to a cell or range of cells in the sheet that you want to find the sheet number for. If the "reference" argument is omitted, the function returns the sheet number of the sheet containing the formula.

Examples

  • =SHEET(Sheet1!A1)

    The SHEET function returns the sheet number of the supplied cell reference. This returns the number 1 because Sheet1 is on the first sheet of the workbook.

  • =SHEET(Sheet2!A1)

    Likewise, you can use the SHEET function to return the sheet number of another cell reference. This returns the number 2 because Sheet2 is on the second sheet of the workbook.

  • =SHEET(Sheet3!A1)

    You can also use the SHEET function to return the sheet number of a third cell reference. This returns the number 3 because Sheet3 is on the third sheet of the workbook.


Summary

The SHEET function is used to return the sheet number of a reference sheet in a workbook. It includes all worksheets and other sheet types in a workbook.

  • The SHEET function returns the sheet number of the reference sheet in a worksheet, which includes visible, hidden, and very hidden worksheets.

Frequently Asked Questions

What is the SHEET function?
The SHEET function is a function in a spreadsheet that returns the sheet number of the reference sheet in a worksheet.
What does the SHEET function include?
  • All worksheets in a workbook
  • All other sheet types in a workbook
How do I use the SHEET function?
You can use the SHEET function to return the sheet number of a reference sheet in a workbook. To do this, you will need to enter the SHEET function into the cell where you want the sheet number to be displayed. The syntax for the SHEET function is SHEET(reference).
What is the syntax for the SHEET function?
The syntax for the SHEET function is SHEET(reference).
What is a reference in the SHEET function?
A reference in the SHEET function is a cell or range of cells that you want to get the sheet number of. You can use any cell or range of cells as your reference.
Can I use the SHEET function in other sheet types?
Yes, you can use the SHEET function in other sheet types. The SHEET function includes all worksheets and all other sheet types in a workbook.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV