The Excel SHEET Function

Related Function:
SHEETS Function

Function Description

The Excel Sheet function returns the Sheet number for a specified reference.

Note: the Sheet function was introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

SHEET( [value] )

Where the supplied [value] argument is a reference to an Excel sheet or a part of an Excel sheet. This is an optional argument which, if omitted, defaults to the sheet that contains the function.

Sheet Function Examples

The spreadsheets below show four examples of the Excel Sheet function.

In the workbook containing the examples:

  A B
1 =SHEET( ) - defaults to the current worksheet
2 =SHEET( "Sheet2" ) - the name of a worksheet named "Sheet2"
3 =SHEET( Sheet2!A1 ) - a reference to a cell in Sheet2
4 =SHEET( "Chart1" ) - the name of a Chart sheet named "Chart1"
  A B
1 1  
2 2  
3 2  
4 3  

For further examples of the Excel Sheet function, see the Microsoft Office website.

Sheet Function Errors

If you get an error from the Excel Sheet function, this is likely to be one of the following:

Common Error
#N/A! - Occurs if the supplied [value] argument is a sheet name that not a valid sheet.
#REF! -

Occurs if the supplied [value] argument is a non-valid reference.

For example, if the [value] argument had previously referenced cell Sheet2!A1, but then Sheet2 was deleted or cell Al within Sheet2 was deleted, this would no longer be a valid reference.