What is SHEET function in Excel?
The SHEET function is one of the Information functions of Excel.
It Returns the sheet number of the referenced sheet.
We can find this function in Information of insert function Tab.
How to use SHEET function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select SHEET function
6. Then select ok.
7. In the function arguments Tab you will see SHEET function.
8. Value section is the name of a sheet or a reference that you want the sheet number of. If omitted the number of the sheet containing the function is returned.
9. You will see the results in the formula result section.
Examples of SHEET function in Excel
1. When you type name of any sheet (for example cell), the sheet function returns the sheet number of referenced sheet.
2. When you choose any cell (for example B2) in the current sheet, sheet function returns the sheet number of the active sheet.
SHEET related functions
- Use SHEETS function to return the number of sheets in a reference.
