In this Article
The SHEET Function returns the numeric index of a sheet in Excel.
Notice how it returns the current sheet number if no reference is given.
SHEET Function with Sheet Name
You can also enter a sheet name into the SHEET Function.
SHEET Function with Cell Reference
If a cell reference is provided, the SHEET Function will return the sheet number of the given cell reference
SHEET Function with a Range
You can input an entire cell range and the SHEET Function will return the sheet number of the respective cell range
Sort Sheet Index
Excel 2019 or older
In Excel 2019 or older, all sheets can be sorted according to their index by using INDEX & MATCH Function
Excel 365 has a new feature: the SORT Function. To sort sheet names based on their index, use the formula: