Skip to content
ExcelExcel 2013+

SHEET function in Excel

Returns the sheet number of the referenced sheet

=SHEET(value)

SHEET syntax and parameters

One argument, zero required.

  • valueanyOptional

    argument. Use this to specify the name of a sheet or a reference for which you want to obtain the sheet number. Otherwise, the function will return the number of the sheet containing the SHEET function.

SHEET examples

Formulas you'll actually reuse.

  1. The position of the current tab in the workbook:

    =SHEET()

    Result3

  2. The position of a tab by name — handy for tab-order checks:

    =SHEET("Budget")

    Result2

SHEET in Google Sheets

Same name — your formula ports as-is.

Try SHEET in the playground

Edit the example — nothing to install.

Preloaded with the SHEET formula from Example 1 — change anything and watch it respond.

Loading the editor…

SHEET errors

What they mean — and the fixes.

  • #N/A

    No sheet has that name, or the reference isn't valid — names are case-insensitive but must otherwise match exactly.

Related functions

More ways Excel gets this done.