Sheet and Sheets Function in Excel 2013

These are new functions introduced in Excel 2013. Here the SHEET() function is used to determine the current sheet on which we are currently working and returns the result as the number that indicates the current sheet. The Sheets() function is used to return the total number of sheets present in the workbook in Excel 2013.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now select the blank workbook template from the available templates.

sheetfunctionofexcel2013.jpg

Step 3

Now take some sheets in our Excel sheet by clicking on the + sign as shown below and give them weekday names like this:

sheetsfunctioninexcel2013.jpg

Step 4

Now write the following formula to determine the current Sheet on which we are working.

sheetfunctioninexcel2013.jpg

Step 5

The output will be like this:

excel2013sheetfunction.jpg

Here 2 indicates the second sheet is the current sheet on which we are working.

Step 6

Now write the following formula to determine what is the number of the sheet named "thu" containing the A1 cell.

excelsheetfunction.jpg

Step 7

The output will be like this:

excel2013sheetfunction1.jpg

Here 4 indicates that the fourth sheet name is "thu" containing cell A1.

Step 8

Now write the following formula to determine the total number of  worksheets present in the current workbook:

sheetsfunctionofexcel2013.jpg

Step 9

The output  will be like this:

 excel2013sheetsfunction.jpg

Up Next
    Ebook Download
    View all
    Learn
    View all