SHEET

Rational

Return worksheet sequence number

Description

The Excel SHEET function returns a sequence number of a worksheet given as a reference in the argument. The formula finds the worksheet number of a given reference, worksheet, named range or table name.

Syntax

=SHEET([value])

Parameters

value [optional] – The name of a sheet or a reference

Return Value

Sheet number

Key Notes

  • The SHEET function is useful to find the sheet number for a given sheet.
  • The function also counts hidden sheets in the workbook.
  • In case optional [value] argument remain empty the resulting value will return the worksheet number of the same cell.
  • The formula return error, #N/A! if sheet name is not valid or #REF! in case the value argument is not valid anymore (delete).

When you have lot of sheet in a workbook to know the number of current page like here we apply formula =SHEET() it return 2.

For example, to know any sheet position we use formula  in cell B9  =SHEET(“Budget”) it return 3. 

 

Keep Reading Similar Functions:

Find about the current operating environment in Excel

INFO

The INFO function get specifications about the current operating environment, include the operating system, Excel version, num. of active worksheets.. so on.

Read More »
Find count of worksheets in a workbook in Excel

SHEETS

The SHEETS function finds the total number of sheets in a workbook. In the case of no argument the function returns total count of active workbook.

Read More »
Find information about a cell in Excel

CELL

The CELL function returns with information of a cell about the formatting, location, or contents. The type of information is based on the info_type parameter.

Read More »