Excel functions / Information

SHEET function

The number of a sheet, counting the tabs from the left: 1 for the first.

Syntax

=SHEET([value])

Arguments

When to use it

SHEET gives the position of a sheet among the workbook's tabs, counting from 1 on the left. With no argument it is the formula's own sheet; with a reference or a sheet's name, that sheet.

Examples

  1. This sheet's number

    AB
    1Sheet1

    In B1: =SHEET() → 1

    Try this example

Common mistakes

SHEET in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try SHEET in the playground

Related functions