Excel functions / Information
SHEET function
The number of a sheet, counting the tabs from the left: 1 for the first.
Syntax
=SHEET([value])
Arguments
value(optional): A reference to the sheet, or its name in quotes. Left out, it is the sheet the formula is on.
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
This sheet's number
A B 1 Sheet 1 In B1:
=SHEET()→ 1
Common mistakes
- A name that is not there. SHEET("Nope") gives #N/A when no sheet has that name.
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.
- Czech: SHEET
- Danish: ARK
- Dutch: BLAD
- Finnish: TAULUKKO
- French: FEUILLE
- German: BLATT
- Hungarian: LAP
- Italian: FOGLIO
- Norwegian: ARK
- Polish: ARKUSZ
- Portuguese (Portugal): FOLHA
- Russian: ЛИСТ
- Spanish: HOJA
- Swedish: BLAD
- Turkish: SAYFA