• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel SHEET Function

You are here: Home / Excel SHEET Function

The Excel SHEET function, new in Excel 2013, returns the sheet number of the referenced sheet based on its position in the file. It can return the sheet number of any worksheet including visible, hidden or very hidden as well as macro, chart and dialog sheets.

SHEET function syntax:

=SHEET(value)

Where value is the name of the sheet or reference you want the sheet number of. The value can include cell references, named ranges or Table names.

You can see it in action in the table below:

Excel SHEET function

Tip: If you enter the SHEET function without a reference e.g. =SHEET() it will return the position of the current sheet.

Use SHEET Function to Return a Sheet Index

Let’s say you have a list of your sheet names in column A and you want to find their position in the workbook. We can use the INDIRECT function to populate the ‘value’ argument by returning the sheet name from column A and appending it to cell reference A1, as shown below:

use SHEET function to return a sheet index

Sort Sheet Index with INDEX & MATCH Functions

We can then use INDEX & MATCH to return a sorted list of the sheets listed in cells A12:A15 based on their sheet position in cells B12:B15:

sort sheet index with INDEX & MATCH functions

If any changes are made to the sheet order, the table above will automatically update.

Sort Sheet Index with SORT Function

Or if you have Office 365 and the new Dynamic Array formulas you can use the SORT function:

sort sheet index with SORT function

Download the Excel Example File

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Excel Sheet Function Related Lessons

Automatically generate a list of sheet names

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.