Buzz
This article introduces you to the SHEET function - one of the functions highly favored in Excel's information category.
Description: Returns the page number value of the referenced worksheet. Supported from Excel 2013 onwards.
Syntax: SHEET(value)
In which:
- value: Represents the name of a worksheet or reference to find the page number, it is a required parameter.
Attention:
- It is advisable to limit the use of this function within formulas as Excel automatically converts when necessary.
Example:
Calculate the page number of the described worksheet in the table below:
- In the cell where you want to calculate, enter the formula: =SHEET(C6)
- Press Enter -> The returned value is:
- Similarly, duplicate the formula for the remaining values to achieve the results:
- You can directly input the worksheet name in the function:
Above is the guidance and some specific examples when utilizing the SHEET function in Excel.
Wishing you all success!
