Tag: SHEET function

SHEET function: Description, Usage, Syntax, Examples and Explanation

by

What is SHEET function in Excel? SHEET function is one of the Information functions in Microsoft Excel that returns the sheet number of the reference sheet. Syntax of SHEET function SHEET(value) The SHEET function syntax has the following arguments. Value(Optional): Value is the name of a sheet or a reference for which you want the sheet …

Continue Reading

List worksheet index numbers in Excel

by

To list the index numbers of sheets in an Excel workbook, you can enter the sheet names, then use a formula based on the SHEET and INDIRECT functions. The SHEET function then returns the current index for each sheet as listed. Formula =SHEET(INDIRECT(name&”!A1″)) Explanation In the example shown, the formula in C5 is: =SHEET(INDIRECT(B5&”!A1″)) How …

Continue Reading