SHEET Function – Get Sheet Index of a Sheet (Excel, Google Sheets)

SHEET Function 

The SHEET Function returns the numeric index of a sheet in Excel. 

=SHEET()

<example 3>

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(“example1”) 

<example 1>

AutoMacro - VBA Code Generator

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(U8)

<example 2>

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

=SHEET(G3:T5)

<example 4>

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

=

<example 5>

Excel 365

Excel 365 has a new feature: the SORT Function. To sort sheet names based on their index, use the formula:

=

<example 6>

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!