Table of Contents
This guide explains how to use SHEET Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the worksheet number of the referenced worksheet. Support functions from Excel 2013 onwards.
Syntax: SHEET (value)
Inside:
- value: The name of a worksheet or reference to find the page number, is a required parameter.
Attention:
- The use of this function should be restricted in formulas because Excel automatically converts as needed.
For example:
Calculate the number of sheets described in the table below:
- In the cell to calculate enter the formula : = SHEET (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- You can enter the worksheet name directly in the function:
Above are instructions and some specific examples when using SHEET function in Excel.
Good luck!
FAQ
What does the SHEET function do in Excel?
The SHEET function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the SHEET function correctly?
Start with an equals sign, enter SHEET, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the SHEET function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Related Articles
Instructions for Copying or Moving Worksheet in Excel 20134 minutes read
Round Function, How to Use Rounded Functions in Excel4 minutes read
How to Use the COUPNUM Function in Excel4 minutes read
How to Use the PERMUT Function in Excel1 minutes read
RANK. AVG Function in Excel3 minutes read
The DAYS Function in Excel3 minutes read
Reader Comments 0
Sign in with email or Google to join the discussion.