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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023

This tutorial demonstrates how to use the Excel SHEET Function to return the index number of a sheet in Excel.

SHEET Function 

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


Sheet Example 03


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 Example 01

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 Example 02

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 Example 04

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


Sheet Example 05

Excel 365

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

=SORT(A2:B6, 2)

Sheet Example 06

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions