Excel SHEET Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel SHEET Function (Example + Sample File)

What is EXCEL SHEET FUNCTION

The Excel SHEET Function is listed under Microsoft Excel's Information Functions category. It returns the sheet number for the reference used. In simple words, the SHEET function returns the worksheet number of the range you referred to in the function.

How to use it

To learn how to use the SHEET function in Excel, you need to understand its syntax and arguments: 

Syntax

SHEET(value)

Arguments

  • [value]: The name of the sheet or reference to any cell in a sheet

Notes

  • It will include all types of sheets (Chart Sheet, Worksheet or Macro Sheet).
  • You can refer to sheets even if they are visible, hidden or very hidden.
  • If you skip specifying any value in the function it will give you the sheet number of the sheet in which you have applied the function.
  • If you specify an invalid sheet name, it will return a #N/A.
  • If you specify an invalid sheet reference, it will return a #REF!.

Example

To master the SHEET function we need to try it out in an example and below is one which you can try out:

In the below example, we have used different inputs to get the sheet number.

Where we have invalid sheet name and invalid sheet reference, the SHEET function has returned an error.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.