Skip to content
Excel

INFO function in Excel

Returns information about the current operating environmentThis function is not available in Excel for the web.

=INFO(type_text)

INFO syntax and parameters

One argument, one required.

  • type_textstringRequired

    Text that specifies what type of information you want returned.

INFO examples

Formulas you'll actually reuse.

  1. How many worksheets are open across all workbooks:

    =INFO("numfile")

  2. Whether calculation is Automatic or Manual — handy in a model's header:

    =INFO("recalc")

INFO in Google Sheets

No direct equivalent — here's the way around.

Try INFO in the playground

Edit the example — nothing to install.

Preloaded with the INFO formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.