인수
value선택
The name of the sheet or a reference to a cell on the sheet you want the number for.
The SHEET function returns the numeric index of a specific sheet within a workbook. If the value argument is omitted, it returns the number of the sheet containing the function.
=SHEET(Sheet2!A1)→2Returns 2 if Sheet2 is the second sheet in the workbook.
Select a cell
Click on the cell where you want to display the sheet number.
Enter the formula
Type =SHEET() to get the current sheet number or =SHEET(SheetName!A1) for a specific sheet.
Yes, the function dynamically updates to reflect the new position of the sheet in the workbook.