SHEET function comes under the INFORMATION category in Excel.
THE SHEET function simply returns the sheet number of any reference given by the SHEET NAME, ANY DEFINED NAME, ANY TABLE NAME ETC.
The SHEET FUNCTION is very useful if we need to find out any reference for any table , any specific range or cell defined by name in any of the sheet. But its important to decide the accessibility of the defined name or range to be workbook so that the function can access it from other sheet.
PURPOSE OF SHEET FUNCTION IN EXCEL
SHEET FUNCTION returns the sheet number of the reference which may be the NAME OF THE SHEET, ANY DEFINED NAME OF A CELL OR RANGE OF CELLS OR ANY TABLE etc.
PREREQUISITES TO LEARN SHEET FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
SYNTAX: SHEET FUNCTION
The Syntax for the function is
REFERENCE/VALUE It contains any value such as NAME OF THE SHEET in the “” or any defined name or Table name etc.
EXAMPLE:SHEET FUNCTION IN EXCEL
For testing the SHEET FUNCTION let us create different entries on the different sheets.
IN SHEET 2, we’ll create a table with the table name GYANKOSH TABLE.
In SHEET 3, we’ll create a cell range named WEEKDAYS.
We’ll name the SHEET 4 as “special cells”
and try to find the sheet number of all these elements from the first sheet of the workbook.
STEPS TO USE TRIM FUNCTION
The text having random spaces has been taken for the example.
We can see that there are some irregular spacing in the line. So we will use the function TRIM to remove those spaces.
The formula used is
The text is stored in D9 which needs to be corrected. The output is shown in E9.
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.