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:
- [value]: The name of the sheet or reference to any cell in a sheet
- 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!.
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.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL CELL Function
- EXCEL ERROR.TYPE Function
- EXCEL INFO Function
- EXCEL ISBLANK Function
- EXCEL ISERR Function
- EXCEL ISERROR Function
- EXCEL ISEVEN Function
- EXCEL ISFORMULA Function
- EXCEL ISLOGICAL Function
- EXCEL ISNA Function
- EXCEL ISNONTEXT Function
- EXCEL ISNUMBER Function
- EXCEL ISODD Function
- EXCEL ISREF Function
- EXCEL ISTEXT Function
- EXCEL N Function
- EXCEL NA Function
- EXCEL SHEETS Function
- EXCEL TYPE Function
About the Author
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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.