PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-SHEETS

INTRODUCTION

SHEETS function comes under the INFORMATION category in Excel.

THE SHEETS function simply returns the NUMBER OF SHEETS in the given workbook or given reference.

The SHEET FUNCTION is very useful if we need to find out the number of sheets contained in a workbook or contained in any reference.

 

PURPOSE OF SHEETS FUNCTION IN EXCEL

SHEETS FUNCTION returns the NUMBER OF SHEETS contained in a workbook or reference.

 

PREREQUISITES TO LEARN SHEETS 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.
Helpful links for the prerequisites mentioned above

SYNTAX: SHEETS FUNCTION

The Syntax for the function is

SYNTAX 1

=SHEETS()

RETURNS THE NUMBER OF TOTAL SHEETS IN THE WORKBOOK. THE SHEETS MAY BE HIDDEN, VISIBLE OR VERY HIDDEN.

SYNTAX 2

=SHEETS(REFERENCE)

REFERENCE It contains any REFERENCE which contains different number of sheets.

Returns the number of sheets contained by the given reference.

 

EXAMPLE:SHEETS FUNCTION IN EXCEL

DATA SAMPLE

For testing the SHEETS FUNCTION let us create different entries on the different sheets.

We have created four sheets in the workbook.
We will find out the total number of sheets using the function SHEETS.
In sheet 2, we have created a cross reference containing sheet 2 and sheet 3. We will try to find out the sheets
involved in this reference using the function SHEETS(REFERENCE).

 

 

EXCEL FUNCTION TRIM
EXCEL:TRIM FUNCTION ANIMATED EXAMPLE

STEPS TO USE SHEETS 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

=TRIM(D9)

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

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: