Excel Functions

Excel SHEETS Function

Pinterest LinkedIn Tumblr

The Excel SHEETS function counts the total number of sheets in a reference. SHEETS will report the number of sheets for a cell reference, named range, or Excel Table.

Purpose of Excel SHEETS Function

To get a number of sheets in a given reference.

Return value

SHEETS returns the number of sheets.


=SHEET ([value])


[value]The value to check.Optional

Usage notes

  • SHEETS includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets).
  • If reference is not a valid value, SHEETS returns the #REF! error value.


Since 2013 for Windows.

Since 2016 for Mac.

Related Posts

Write A Comment