Excel - The Excel SHEET 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 examples of the Excel Sheet function.

In the workbook containing the examples:

• The current worksheet (that contains the functions) is sheet number 1;
• A worksheet named "Sheet2" is sheet number 2;
• a sheet named "Chart1" is sheet number 3.

Sheet Function Errors

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

Common Error