Cellgrids Cellgrids
Home › Excel formulas › Information › SHEETS

SHEETS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SHEETS is an Excel Information function. Returns the number of sheets in a reference.

SHEETS syntax

=SHEETS([reference])

Arguments

When to use SHEETS

SHEETS is used to check the state or type of a cell before other formulas act on it.

Practice SHEETS online, free

Open the live Excel-style spreadsheet and try SHEETS yourself. No Excel install or sign-up needed to start.

Practice SHEETS now →

More Information functions

Frequently asked questions

What does the SHEETS function do in Excel?

Returns the number of sheets in a reference.

What is the syntax of SHEETS in Excel?

The syntax is =SHEETS([reference]). reference: The cell or range being referenced (optional).

Where can I practice SHEETS online for free?

Open the free live spreadsheet on Cellgrids and try SHEETS yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Information functions · Excel case studies · Excel tutorials · Excel shortcuts